	AllExperts > Microsoft Word
	Search

About Aidan Heritage
Expertise
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions of Word from 2 onwards

You are here: Experts > Computing/Technology > Microsoft Software > Microsoft Word > Printing Labels - Using mail merge

Microsoft Word - Printing Labels - Using mail merge

Expert: Aidan Heritage - 11/4/2009

Question
Hi Aidan,

We have a excel spreadsheet where I have stored the address of all my customers with there names, city, zip. I want print out these addresses on the labels size/model 5163.

I am using Mail merge in MS Word to bring in all the contacts in Labels. The problem I am having is when I print these labels there is duplication in the print outs.

For Ex
1. I print the first page of the labels 1-10 in number on a single page.

2. When I print the second page, the address on the first label just moves to next slot in the page and prints again in the next page. Due to which I am printing the same address again and again. I have some 180 addresses in my excel file, which should take 18 pages with 10 address/page.

Can you tell me where I am going wrong in my method. I have 2003 VERSION of MS office.

Thanks

Saurabh

Answer
The mail merge SHOULD consist of a page of labels, each one one cell in a table and each one EXCEPT the last should have a NEXTREC field - merging all records (I suggest to document) would produce one long document of all labels. This is the process but notsure what bit of the process you haven't done/hasn't worked for you. My email if it helps is aidan.heritage@virgin.net

Add to this Answer Ask a Question

About Microsoft Word
This topic answers questions related to Microsoft Word stand-alone or Mircrosoft Office Word including Word 2003, Word 2007, Office 2000, and Office XP. You can get Word help on formatting text, tables, tabs, fonts, styles, general Word layouts, bullets, headings, and outlines, using templates, toolbar modifications, and using Track Changes. You may also find tips on linking Word and Excel embedded objects including charts. This site does not provide a general Word tutorial nor the basics of using a word processor. It provides specific answers to using Microsoft Word only. If you do not see your Word question answered in this area then please ask a Word question here