Changing recipient name in a letter draft in MS word from a list in MS Excel

[piku9290dgp]

Dear Excel Helpers,

I need a help in excel macro. I have a word with draft of letter, and an excel sheet with list of recipients. I want to create a macro in which following actions happen
1. change the recipients name in the letter in MS Word from the list of names in excel
2. save the word document document with recipient name.

Thank you.

Letter Draft in Word;

To
XYZ - This name to be replaced with every macro click


List of names in excel -
1. wew
2. wgr
3.oek
4. wmjk

 

[Macropod]

See Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html