Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
At my wit's end in Huntsville At my wit's end in Huntsville is offline
external usenet poster
 
Posts: 1
Default How do I get an Excel Contacts List into Mailmerge for Labels?

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!!!!!!!!
  #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!!!!!!!!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge labels excel 07 to word 07 Craigm Mailmerge 3 June 11th 09 05:42 AM
How do I insert Excel values in Word labels without mailmerge? Terp Tables 1 March 30th 06 09:48 PM
How do I do mailing labels from my list in Excel HIM Mailmerge 1 October 12th 05 03:14 AM
MS Word problem: Click to open contacts from Contacts list Carolan Microsoft Word Help 2 April 11th 05 04:12 PM
Import converter Excel to Word for labels mailmerge Brodie Microsoft Word Help 2 March 3rd 05 12:38 PM


All times are GMT +1. The time now is 06:15 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"