How do I get an Excel Contacts List into Mailmerge for Labels?

[At my wit's end in Huntsville]

I know something is wrong, but here is what I'm doing: 1. Tools-mailmerge;
2. labels; 3. Label options (5260 address); 4. next:select recipients; 5.
Browse (go to excel document); 6. Mail merge recipients (I choose first line
and check "First Row Data Includes Headers"); 7. OK; 8. Next: Arrange
labels; 9. Select "More Items"; Select Occupant, St Number, St#Number, City,
St Zip, and then "close"; 10. Update all labels; 11. Next: Preview your
labels; 12. Complete merge.

Then, the preveiw contains just one page of my labels and when I print,
though I should have 9 pages of labels I get about 23 pages and many are
duplicated in no rational order. I know when it is correct, I can actually
preview all pages of the labels but when it is not right, I just preview one
page. CAN ANYBODY HELP ME???
YYYYIIIIIIIIIII!!!!!!!!

 

[Doug Robbins - Word MVP]

Almost certainly, you have not actually executed the merge, which you must
do either to a printer or to a new document. Rather than that, you are just
printing a preview of the result.

See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"At my wit's end in Huntsville" <At my wit's end in
(e-mail address removed)> wrote in message
news:[email protected]...