Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
how do I print address labels from an Excel Spreadsheet
I am trying to print address labels from information contained within a
spreadsheet, I have the normal columns you would see in an address, first name, last name, golf club, address 1, address 2, address 3, address 4, postcode. I would like there to be 14 labels per page. Thanks |
#2
|
|||
|
|||
how do I print address labels from an Excel Spreadsheet
sq, I would do a mail merge with word
For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm A training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "sq" wrote in message ... I am trying to print address labels from information contained within a spreadsheet, I have the normal columns you would see in an address, first name, last name, golf club, address 1, address 2, address 3, address 4, postcode. I would like there to be 14 labels per page. Thanks |
#3
|
|||
|
|||
how do I print address labels from an Excel Spreadsheet
Use mail merge feature in MS Word for printing labels, and set that databese
is excel file where you hold addresses. Word will guide you throught process. Consult Word help for mail merge if you need it. "sq" wrote in message ... I am trying to print address labels from information contained within a spreadsheet, I have the normal columns you would see in an address, first name, last name, golf club, address 1, address 2, address 3, address 4, postcode. I would like there to be 14 labels per page. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put a button on an excel spreadsheet to print a report? | Excel Discussion (Misc queries) | |||
how to format and print labels from an excel file | Excel Discussion (Misc queries) | |||
Why when I print out a spreadsheet on Excel it doesn't have lines | Excel Discussion (Misc queries) | |||
Convert Word labels to Excel spreadsheet | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |