In the post today, I’m going to look at how you can use your Excel list of names, addresses and email addresses to send a mass mailing (mail merge).

However, one thing I would say is that if you find yourself doing this regularly, you would probably be better off investing in something like AWeber (which allows you to target specific lists, easily create newsletters, schedule automatic mailings, create autoresponders) or Mailchimp.

In this video, I’m going to look at how you would create an email shot using your Excel list.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/email_shot_excel.m4v’]

 

In this video, I’m going to look at how you would create a set of letters to send to your customers.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/letter_mail_shot_from_excel.m4v’]

 

 

 

You can use the file here to practise on.