When you're doing a mail merge, it could be with a form letter, it could be with labels, it could be envelops. Click file, then new, and select blank document. Keep it in mind as we switch over to Microsoft Word now and start a new blank document. We don't have to use all of the fields when we perform a mail merge in Microsoft Word. You may have additional fields like company name and titles, et cetera. Then we have city, state, zip, country, even though most of them are USA, there is one that's not, we'll keep that in mind. Notice that some of them have and some of them do not have contents in those fields. One for the main street address and if there are any units or apartments, there's a separate column for that. First name is separate from last name, for example. You wanna separate them out as best as possible. You'll notice that there are a number of columns and each of these columns represents a single field. If you have the exercise files, open up Contacts067. A lot of automation is built right in to this particular scenario and that's what we're going to explore in this week's Word Tip. The answer is a resounding yes, it's actually quite easy. I often get asked by people who have contact information stored in an Excel spreadsheet if they can use that spreadsheet in a mail merge in Microsoft Word.

Quick spreadsheet mail merge