The automatic addition of names and addresses from a database to letters and envelopes in order to facilitate sending mail, especially advertising to many addresses.
Excel spreadsheet that contains the variable data for letters
Create a Microsoft Word letter with common content
- In below picture Name, Company name and Position are variables/ Place holders
In Microsoft Word click as numbered below, it opens Mail merge step by step wizard window
Step 1: click "Next: Starting Document" on the bottom of the Wizard
Step 2: choose "Use the current document"
Step 3: choose "Use an existing list" then Browse for Database sheet Select and click "OK"
- Select recipients from the selected sheet
- Create merge fields. Highlight 'Name' then choose 'Name' from insert merge field
- After creating merge fields click on "Next: Write your letter"
Step 4: click on "Next preview your letters" to check whether fields displayed correctly
Step 5: click on "Next: Complete the merge" to complete merge action
Step 6: click on "Print" to print the letters/ click on "Edit individual letters" to edit
