i using excel 2003; i have a form letter to send to about 120 individuals; i
have names and addresses as labels in columns A amp; B in my spreadsheet. how do
i take names and addresses from excel and insert each into my Word generated
letter ?
Here are a couple of links:
www.mvps.org/dmcritchie/excel/mailmerg.htm
www.mvps.org/word/FAQs/MailMerge
The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.
terwanley wrote:
gt;
gt; i using excel 2003; i have a form letter to send to about 120 individuals; i
gt; have names and addresses as labels in columns A amp; B in my spreadsheet. how do
gt; i take names and addresses from excel and insert each into my Word generated
gt; letter ?
--
Dave Peterson
For help on Word mail merge using Excel as the data source.
www.mvps.org/dmcritchie/excel/mailmerg.htm
www.mvps.org/word/FAQs/MailMe...AMailMerge.htm
www.mvps.org/word/FAQs/MailMe...DataSource.htm
And a training tutorial for creating envelopes and labels.
office.microsoft.com/training...tID=RC01039029...Gord Dibben Excel MVP
On Thu, 19 Jan 2006 08:47:04 -0800, terwanley
gt; wrote:
gt;i using excel 2003; i have a form letter to send to about 120 individuals; i
gt;have names and addresses as labels in columns A amp; B in my spreadsheet. how do
gt;i take names and addresses from excel and insert each into my Word generated
gt;letter ?
Gord Dibben MS Excel MVP
- Nov 03 Mon 2008 20:47
how do I merge labels onto a seperate form letter ?
close
全站熱搜
留言列表
發表留言