Nepal Oil Corporation2075 BSQuestion 4 of 5
Describe Mail Merge feature in MS Word. Write the steps that you follow in order to create a Macro in MS Word.
10 marks
Question source
- Exam year
- 2075 BS / 2018 AD
- Level
- Level 4 (Prabidhik, Bibidh, Sahayak – Computer)
- Paper
- Section B – Subjective
- Section
- Section B: Subjective
Model answer
Mail Merge generates many personalized letters from one template + Excel list (e.g. NOC rate notices to 200 dealers). Steps: prepare Excel (Name|District|Rate) → type body in Word → Mailings → Start Merge → Letters → Select Recipients (Excel) → Insert Merge Fields → Preview → Finish & Merge (Print/Email).
Macro in Word (automate repeats): A macro records/plays keystrokes via VBA — e.g. auto-format daily stock table.
- View → Macros → Record Macro → name
FormatStock, store in document. - Perform steps once (bold header, set font, add borders).
- Stop Recording.
- Run: View → Macros → View Macros →
FormatStock→ Run on tomorrow's file. Assign button/shortcut for one-click use. - Caution: enable only trusted macros (macros can carry viruses); save as
.docmif macro must travel with file.
Merge = many outputs, Macro = one-click repeat.