How to do a Email Merge in Word 2007

Because someone else is going to ask and I'm not going to remember where I saved the file...

Note: This will only work if you're using Word 07 and Outlook is your default email client.

  1. Click on the Mailings tab
  2. Click Start Mail Merge and choose Email Messages
  3. Click Select Recipients and choose Use Existing List
  4. Browse to your Excel File containing the email addresses (If you don't already have one you can go into excel and create it now and then come back)
  5. Click Open
  6. Compose your email
  7. Insert any merge fields that you want by clicking on Insert Merge Field and choosing the appropriate column name from your Excel file
  8. Click Finish and Merge and choose Send Email Messages
  9. In the "To" dropdown choose the name of the heading of the column in your excel file that contains the email addresses
  10. Compose a Subject line in the "Subject line" blank
  11. Chose between Text and HTML in the mail format blank (only use HTML if you have links or other formatting in your email that you would like for the recipients to see)
  12. Click OK
And this moment of Wordiness brought to you by Work Lesley. ;-)


Popular posts from this blog

The Truth in the Tale: Legends of King Arthur

Transforming my Kitchen

The "Why" of Me