Some Mail Merge Examples

How you print mailing labels in MSWord depends on how you entered the data in your Excel spreadsheet. At http://www.macolabels.com we see customers who enter address data in Excel in a variety of ways.
The most common way to enter data in Excel is to enter data in assigned columns. The 1st column, column A might be NAME. The 2nd column, column B COMPANY, column C ADDRESS, column D CITY, column E STATE, and column F might be ZIP. Often times, column D, E, and F are put into one field as CITYSTZIP.
If you entered the data in this manner, you will need to create a primary merge document that looks like this:
http://www.macolabels.com/templates/ml-3000-primary.doc
This primary merge document is the same layout as the laser label that Avery makes, the Avery 5160 laser label. It’s also inkjet compatible.

And your address list could look like this:
http://www.macolabels.com/templates/addresslist.xls

For an in detailed tour of the mail merge procedure, check out Microsoft’s site:
http://office.microsoft.com/en-us/help/ha010349201033.aspx

Some of our users also enter their address data in to an excel spreadsheet as it might appear on a label. That is, each cell contains the data that prints out on a label.
Something like this:
http://www.macolabels.com/templates/addresslist2.xls
To make this document so that you can merge it with a primary document, make the document into a one column document so that it looks like this:
http://www.macolabels.com/templates/addresslist3.xls
You would then create a primary merge document that would look like this:
http://www.macolabels.com/templates/ml-3000-primary3.doc
Make sure you’ve clicked on the Mailings tab so that you have all the Merging functions to choose from.

Advertisements

Tags: , , , , , , ,

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s


%d bloggers like this: