Sachin Filinto Blog Using Mailmerge to send bulk customized e-mails. - Random Technical Artices By Sachin Filinto - Site Home - TechNet Blogs

Random Technical Artices By Sachin Filinto

Random Technical Artices By Sachin Filinto

Using Mailmerge to send bulk customized e-mails.

Using Mailmerge to send bulk customized e-mails.

  • Comments 1
  • Likes

 

Ever wanted to send an invite to a whole lot of people by e-mail & wanted it to look professional rather then sending a generic one to all users Bcc'ed ?

 

Here is a method to generate bulk personalized e-mails to  a set of uses ( from a list ) using the mail Merge Feature of Microsoft Word. ( Outlook used to send the e-mail )

 

  • Add the Recipients to your outlook contacts ( Highly recommended as this would simplify the steps later on -

If needed create a subfolder in the contacts folder. )

 

  • Open Microsoft Word.
  • Select the "Mailing" tab from the ribbon.
  • Start mail merge > e-mail messages.

Here Type the body of your e-mail.

 

  • "Select recipients" > Select from outlook contacts
  • Preview the e-mail by selecting the "Preview Results"  Icon.
  • Click on Finish & merge
  • Click on Send e-mail Messages
  • Type the Subject of the e-mail
  • Click on Ok.

 

 

Further Options to customize the e-mail

  • You can Customize the  Greeting from the below menus

Greeting Line Or Insert Merge Field ( More Granular control )

e.g. Each e-mail could be customized with a Dear Mr. xyz ( Pulled from the contact information )

 

 

For more information : read the word help file. ( It has detailed instructions on all the options you see on the ribbon )

Lesson Learnt the Hard way:

 

Keep your machine Disconnected from the network ( or Keep outlook offline )

 

After the mails are generated, review them from the outlook outbox. If the e-mails are as expected, go ahead & make outlook online to have the e-mail sent.

Comments
  • Wow that's a very nice tip, thanks.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment