Mail Merge Instructions
- Paul Petrin
Follow these instructions to complete a mail merge.
Required Files for this Guide
You will need to download the following files to your computer to complete this activity:
Step-by-step guide
1. Open Spreadsheet – Mailmerge, fill in the Serial Number, Email and First Name columns. Hit save:
2. Open MailMerge Doc in Microsoft Word. Select the (1) Mailings tab > (2) click Select Recipients > (3) Use Existing List:
3. In the "Select Data Source" window, browse to the saved file Spreadsheet – Mailmerge, select it and click Open:
4. In the "Select Table" window, ensure the checkbox beside First row of data contains column headers is checked and click OK:
4. Click (1) Finish & Merge > (2) Send Email Messages...:
5. Enter a subject in the Subject line field and click OK:
