Mail Merge Using Microsoft Word and Excel

We see it everyday, personalised emails, letters and brochures sent to us. It makes it feel like someone has made the extra effort to write to us. As it happens this is quite easy to do using a feature in Microsoft Word call Mail Merge. It allows you to create a letter, label, email or other document and using a database of names and information add that to create individual documents. The document can then be printed, saved or sent out as an email.

Excel is very popular and is often used to create lists of information, also known as a database. Although a mail merge can be done from many other databases I have chosen to use Excel here as it is popular and easy to use. See the videos below on how to use it. The videos are similar but one is a mail merge to a letter for printing and the other is to send by email.

Coming up for the holidays you might find this useful for dropping a personalised line to all your family, friends and colleagues.

Mail Merge to Letter

Mail Merge to Email

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Microsoft Office, microsoft word, Office 2010, word, word 2010 and tagged , , . Bookmark the permalink.

One Response to Mail Merge Using Microsoft Word and Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s