View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
blakepm blakepm is offline
external usenet poster
 
Posts: 1
Default 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!