ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I take excel data and convert to label/envelope form? (https://www.excelbanter.com/excel-worksheet-functions/19711-how-do-i-take-excel-data-convert-label-envelope-form.html)

Vivian

How do I take excel data and convert to label/envelope form?
 
My spreadsheet has Title-first name, last name, street,city , state and zip
in individual columns. How can I easily put in envelope form without
retypying?

Paul B

Vivian, do a mail merge with word,
For help on Word mail merge using Excel as the data source have a look here

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
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Vivian" wrote in message
...
My spreadsheet has Title-first name, last name, street,city , state and
zip
in individual columns. How can I easily put in envelope form without
retypying?





All times are GMT +1. The time now is 10:50 AM.

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