Create Mailing Labels in Word 2003 With Mail Merge

Author: mety Nagm Labels::

You can use Mail Merge in Word 2003 to create mailing labels for a database full of customers.
Open Word 2003 and click on Tools \ Letters and Mailings \ Mail Merge…

In the Mail Merge menu on the right under Select document type, select Labels. Then click Next: Starting document.

From step 2 Click on Label options…

This will bring up a menu allowing you to select the brand and style of the labels you want to print. Here I am using Avery 4013 on a Dot Matrix printer. Of course you will want to select what you have, Avery is the most popular in business from my experience. If you have oddball labels you can always choose custom settings as well. When your done with the label options click OK.

Now you are going to want to choose your data source. Under Use an Existing List; click on Browse… Use Explorer to find the data source you want to use and double click it. (Creating a data source will be covered in another how to).

You will click on a confirmation screen verifying your data source (I used an Excel spread sheet that I had imported from Access) and get to Mail Merge Recipients window. Here you can change the order of your information, delete certain users, and validate information. Since I know the data source is what I want I chose Select All. Now hit OK.

Ok, we're almost complete, just a couple more steps. Click on Next: Arrange your labels.

Here Click on More items…

Now we can choose the order of the data we want presented on the labels we are creating. Just double click on each field you want to include.

Now if you look over at your document you will notice these fields are being added to your labels. You can edit them by highlighting the field and moving it to where you want. For instance on this label I would want the First Name before the Last Name.

Now over on the Mail Merge menu bar you will want to select the "update all labels" button. This will populate each label with the fields from the fist label. Then click on Next: Preview your labels.

Your document screen will look similar to this.

Now, on the mail merge menu you can click through the Recipients by clicking the back or forward arrows. If you doing hundreds of labels … I would just spot check them. If you're satisfied with how they look let's move to step 6 and complete the merge.

The Merge is complete! Make sure your labels are set up in the printer and hit Print…

You will be presented with the print select screen. Choose all, or a specific number to print. You will get a different record for each contact from your data source on each label.

  1. Anonymous 2:26 AM

    Great! But I have strange problem on this multiple mail merge. I have database on excel sheet about 200 names with addresses.

    Finally, the first page is OK since they are different names BUT at page 2, only one name is different from page one - the rest are the same name at page 1. They were repeated at page 2 and so on... each page has contain one new name only from database.

    I had 14 labels on each portrait page. I should say 2 columns each portrait page at 7 labels on each column so they were 14 labels each page.

    have I missed something? why names are randomly repeat on each page apart from first page? On my 200 names at excel data sheet, it also printed 200 pages label sheets on 14 label each page. Please help, I am indeed desperate!




Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2