Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
Mailing labels, mail merge | Excel Discussion (Misc queries) | |||
Making Mailing Labels | Links and Linking in Excel | |||
How do I make mailing labels from an excel document? | Setting up and Configuration of Excel | |||
how do I convert a list in Excel to mailing labels | Setting up and Configuration of Excel |