Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adjust line spacing when printing address labels in Excell ? | Excel Worksheet Functions | |||
Printing Problems in Excel due to a Macro in Word?! | Excel Discussion (Misc queries) | |||
Contact List in Excel - Printing Labels in Word | Excel Discussion (Misc queries) | |||
Problems printing a word document with linked excel tables. | Excel Discussion (Misc queries) | |||
When printing labels by using Excel data in a Word mail merge, ho. | Excel Discussion (Misc queries) |