ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I print address labels from an Excel Spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/53361-how-do-i-print-address-labels-excel-spreadsheet.html)

sq

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

Paul B

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




Mladen_Dj

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





All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com