Importing List from Excel to Word printing labels spacing problems

[blakepm]

When I import my mailing list from Excel to Word to print mailing labels (30
per page) my labels have large spaces between the lines. For example they
look like this:

John Doe

P.O. Box 000

City, State, Zip

And then if I have a business name before John Doe it gets cut off. Is there
a way to decrease the space between the lines so it fits better? I have
figured out how to do one at a time, but we have 4,000 of these to print!

I would like it to look like:

John Doe
P.O. Box 000
City, State, Zip

Thanks for any help!

 

[David Biddulph]

Sounds like a question for a Word newsgroup, not for Excel.
Have you looked at Word help on producing labels with mail merge?
http://office.microsoft.com/en-us/excel/HP052037601033.aspx for basic
instructions.
http://office.microsoft.com/en-us/word/HA102264141033.aspx for a demo.