Mail merge from excel file to produce labels for mass mailing

[Jeanie]

I am trying to create labels from an excel spreadsheet containing names and
addresses. I use the mail merge wizard in word. I should end up with 3 and a
half sheets of labels (30 labels to a sheet). Instead, I'm ending up with
125 as it is putting one record on each page!

Help!

 

[Michael]

Hi Jeanie,
I don't have an answer for your questions, but I have the post right below
yours. Could you take a look at it and provide me suggestions. Basically I'm
trying to print label in Word 2003 from Excel 2003 and when I follow the mail
merge instructions, but when I select my excel file I get black labels on the
screen.

Thanks for any help.
Michael

 

[Doug Robbins]

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

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


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Jeanie]

Thank you! My wizard steps don't mention the propagate icon and I have
never used it/seen it before! I have my labels.

Jeanie