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 & 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:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

terwanley wrote:

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 & B in my spreadsheet. how do
i take names and addresses from excel and insert each into my Word generated
letter ?

--

Dave Peterson

For help on Word mail merge using Excel as the data source.

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

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...tID=RC01039029...


Gord Dibben Excel MVP




On Thu, 19 Jan 2006 08:47:04 -0800, terwanley
wrote:

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 & B in my spreadsheet. how do
i take names and addresses from excel and insert each into my Word generated
letter ?

Gord Dibben MS Excel MVP