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?