ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I create mailing labels from microsoft excel (https://www.excelbanter.com/new-users-excel/83590-how-do-i-create-mailing-labels-microsoft-excel.html)

Tim Malle

How do I create mailing labels from microsoft excel
 
I'm fairly new to Excel. I want to merge names and address information from
different colums. Then I want to create mailing labels. Can someone help me
with this?

Nick Hodge

How do I create mailing labels from microsoft excel
 
Tim

You are better to se the mailmerge feature in Word and use you names and
addreses in Excel as the datasource

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Tim Malle" <Tim
wrote in message
...
I'm fairly new to Excel. I want to merge names and address information
from
different colums. Then I want to create mailing labels. Can someone help
me
with this?




David McRitchie

How do I create mailing labels from microsoft excel
 
Hi Tim,
Using MS Word with Excel as the database,
be sure to move the worksheet tab so that it becomes the first worksheet in the workbook.
Then continue with
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
which is specifically for printing labels.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nick Hodge" wrote in message ...
Tim

You are better to se the mailmerge feature in Word and use you names and
addreses in Excel as the datasource

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Tim Malle" <Tim
wrote in message
...
I'm fairly new to Excel. I want to merge names and address information
from
different colums. Then I want to create mailing labels. Can someone help
me
with this?






Gord Dibben

How do I create mailing labels from microsoft excel
 
And for help with Nick's suggestion...........

For help on Word mail merge using Excel as the data source.

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

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP


On Mon, 17 Apr 2006 19:48:20 +0100, "Nick Hodge"
wrote:

Tim

You are better to se the mailmerge feature in Word and use you names and
addreses in Excel as the datasource




All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com