ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mailing Labels (https://www.excelbanter.com/excel-discussion-misc-queries/57010-mailing-labels.html)

Monica

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?

Peo Sjoblom

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?




Nick Hodge

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