Importing List from Excel to Word printing labels spacing problems
 

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!

Importing List from Excel to Word printing labels spacing problems
 

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/ex...037601033.aspx for basic
instructions.
http://office.microsoft.com/en-us/wo...264141033.aspx for a demo.
--
David Biddulph

"blakepm" wrote in message
...
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!