[salgud]

Trying to do my first mail merge to create labels from an XL list in
Word 2003. What a mess! I waded through it all, but I'm getting a very
weird result. Instead of one label for each person, I'm getting a page
of labels for each person, but not with all the labels that same
person. There is a page for each person on my list as the first label,
then the next 13 labels are for the next 13 people on the list! So the
first page has the first 14 (14 labels to a sheet) people on the list,
the second page starts with the second person on my list and ends with
the 15th person, and the third label starts with the third person on
the list and ends with the 16th person, and so forth.

Does anyone have a clue as to what is happening? Better yet, how to
fix it?

Thanks!

[Peter Jamieson]

You are probably /previewing/ the merge, rather than "completing" the
merge by merging to an output document or merging to the printer (which
is different from printing the mail merge main document). If you are
using the Mail Merge Wizard, get to "Step 6 of 6" in the Wizard, then
use the Print... option to merge to printer, or the "Edit individual
labels" option to merge to a new document.

Alternatively, in many cases it can be easier to enable the Mail Merge
toolbar (View-Toolbars) then use the appropriate button near the
right-hand end to merge to printer or to a new document.

Peter Jamieson

http://tips.pjmsn.me.uk

salgud wrote:
Trying to do my first mail merge to create labels from an XL list in
Word 2003. What a mess! I waded through it all, but I'm getting a very
weird result. Instead of one label for each person, I'm getting a page
of labels for each person, but not with all the labels that same
person. There is a page for each person on my list as the first label,
then the next 13 labels are for the next 13 people on the list! So the
first page has the first 14 (14 labels to a sheet) people on the list,
the second page starts with the second person on my list and ends with
the 15th person, and the third label starts with the third person on
the list and ends with the 16th person, and so forth.

Does anyone have a clue as to what is happening? Better yet, how to
fix it?

Thanks!

[Graham Mayor]

You may find http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
useful.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



salgud wrote:
Trying to do my first mail merge to create labels from an XL list in
Word 2003. What a mess! I waded through it all, but I'm getting a very
weird result. Instead of one label for each person, I'm getting a page
of labels for each person, but not with all the labels that same
person. There is a page for each person on my list as the first label,
then the next 13 labels are for the next 13 people on the list! So the
first page has the first 14 (14 labels to a sheet) people on the list,
the second page starts with the second person on my list and ends with
the 15th person, and the third label starts with the third person on
the list and ends with the 16th person, and so forth.

Does anyone have a clue as to what is happening? Better yet, how to
fix it?

Thanks!