User Tools

Site Tools


vsvwiki:mailmerge

This is an old revision of the document!


Mail merge for dummies

Mailmerge is a good way to make your mass-mailing seem more personal and appealing. It's not as difficult as you think, and it's a good skill to have.

A mail merge can be executed in the following steps:

  1. In Outlook, go to “account settings” and set the desired address to send from as default.
  2. In options, go to the tab “Mail” and tick “Always use the default account when composing new messages” under “Send messages”.
  3. Close Outlook and open Word.
  4. Under the tab “Mailings”, go to “Start Mail Merge” and select “E-Mail Messages”.
  5. Go to “Select Recipients”, “Use an Existing List”, and load the sheet containing the data you want to merge on. Check if all data is correct by clicking “Edit Recipient List”.
  6. Type your e-mail.
  7. If you want to include a merge field, like a name to use when addressing the recipient, click on “Insert Merge Field” and select the field you want to include.
  8. When you're done writing, click “Finish and Merge” to send the e-mail.
  9. Fill in the e-mail subject, select the recipient e-mail field to merge on, if Word can't detect it automatically, and press “Ok”.
  10. That's it!

Always send a test e-mail before you send out the entire batch, to check that the merged fields, addressing, and (in particular) the sending e-mail address are correct.

vsvwiki/mailmerge.1623165768.txt.gz · Last modified: 2021/06/08 17:22 by bestuah1945