Mailing Labels

[Monica]

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?

[Peo Sjoblom]

Yes, but you should use Word as malmerger abd excel as source


http://www.mvps.org/dmcritchie/excel/mailmerg.htm

--

Regards,

Peo Sjoblom


"Monica" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Nick Hodge]

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
[email protected]HIS


"Monica" <[email protected]> wrote in message
news:[email protected]...
>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?