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

piku9290dgp

New Member
Joined
Jun 28, 2017
Messages
3
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
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,095,809
Messages
5,446,620
Members
405,411
Latest member
mar5del

This Week's Hot Topics

Top