[VK]

Gurus,

Need a help with Word 2007 Macros.
The requirement is to create the letter and insert the data from an excel
sheet in between the letters. I have the letter format and the excel data.
The sample letter format is:
----------------------------------------------------------------------------
To
Name
Street
City, State Zip

Dear Sir/Madam,

According to our records, the Inv nbr xxxxxx has been defaulted with $
xxx.xx. Please pay the amount on or before Apr 15, 2010.

Sincerely


XYZ Company.

----------------------------------------------------------------------------

As I said before, I have the data for the Inv Nbr, the amount, Name, address
etc.
How and where do I start with this request.

Please help.

[Graham Mayor]

On the face of it a letter mail merge should fit the bill - see
http://www.gmayor.com/merge_labels_with_word_2007.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"VK" wrote in message
...
Gurus,

Need a help with Word 2007 Macros.
The requirement is to create the letter and insert the data from an excel
sheet in between the letters. I have the letter format and the excel data.
The sample letter format is:
----------------------------------------------------------------------------
To
Name
Street
City, State Zip

Dear Sir/Madam,

According to our records, the Inv nbr xxxxxx has been defaulted with $
xxx.xx. Please pay the amount on or before Apr 15, 2010.

Sincerely


XYZ Company.

----------------------------------------------------------------------------

As I said before, I have the data for the Inv Nbr, the amount, Name,
address
etc.
How and where do I start with this request.

Please help.