View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I get an Excel Contacts List into Mailmerge for Labels?

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_lab...th_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
wrote in message
...
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!!!!!!!!