close

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 Govierquot;Caitlinquot; gt; wrote in message
...
gt; How do I convert an Excel document containing 3 columns of names and
gt; addresses into a document (pref into Microsoft Word template) to
gt; create a
gt; mailing label document with out individually coping and pasting each
gt; name and
gt; address?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()