![]() |
Mailing Labels
I have a spreadsheet that I set up to use to track potential clients. I want
to use some of the information from the spreadsheet to create mailing labels. For instance: Column 1 = Contact Name Column 2 = Company Name Column 3 = Address Column 4 = Phone Number Column 5 = Misc. information I only want to print the information from the first three columns into mailing labels. Is this possible? |
Mailing Labels
Yes, but you should use Word as malmerger abd excel as source
http://www.mvps.org/dmcritchie/excel/mailmerg.htm -- Regards, Peo Sjoblom "Monica" wrote in message ... I have a spreadsheet that I set up to use to track potential clients. I want to use some of the information from the spreadsheet to create mailing labels. For instance: Column 1 = Contact Name Column 2 = Company Name Column 3 = Address Column 4 = Phone Number Column 5 = Misc. information I only want to print the information from the first three columns into mailing labels. Is this possible? |
Mailing Labels
Monica
Use Word's mailmerge facility, which includes label printing in huge detail...when it asks for a datasource, navigate to your Excel file. This way you can add the fields you want...filter records, etc -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Monica" wrote in message ... I have a spreadsheet that I set up to use to track potential clients. I want to use some of the information from the spreadsheet to create mailing labels. For instance: Column 1 = Contact Name Column 2 = Company Name Column 3 = Address Column 4 = Phone Number Column 5 = Misc. information I only want to print the information from the first three columns into mailing labels. Is this possible? |
All times are GMT +1. The time now is 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com