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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks