ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Coverting an Excel document (https://www.excelbanter.com/excel-discussion-misc-queries/69768-coverting-excel-document.html)

Caitlin

Coverting an Excel document
 
How do I convert an Excel document containing 3 columns of names and
addresses into a document (pref into Microsoft Word template) to create a
mailing label document with out individually coping and pasting each name and
address?

Roger Govier

Coverting an Excel document
 
Hi Caitlin

Don't copy the data anywhere.Ensure you have headers to your data in
your Excel sheet..
In Word, use the Mailmerge wizard, and in Step 3 tell it to use an
existing list and Browse to your Excel file.
You will then see you can incorporate your data into labels or into a
form letter.
You can also filter to select which names to use.

--
Regards

Roger Govier


"Caitlin" wrote in message
...
How do I convert an Excel document containing 3 columns of names and
addresses into a document (pref into Microsoft Word template) to
create a
mailing label document with out individually coping and pasting each
name and
address?





All times are GMT +1. The time now is 03:46 AM.

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