Replace names and save master document from a list

Question

For my work I need to compose a letter to print that will go to a number of employees. Everyone will receive the same letter, but with their name in two places. Is there a way that I can create a "master document" and a list of names and have the name from the list be input and a new copy of the file saved, and have it do this for every name in the list. 

If this is possible, is there a way I could replace other text within the document? If not, is there a way I could do it with a batch file or something similar? Thanks!

Answer 1

Use Mail Merge.

See the article “Mail Merge with Word 2007/2013” on fellow MVP Graham Mayor’s website at

http://www.gmayor.com/merge\_labels\_with\_word\_2007.htm

Answer 2

You could use a macro-driven mailmerge for this.

For the mailmerge basics, see:

https://support.office.com/en-us/article/Word-mail-merge-A-walk-through-the-process-4AD61088-E108-4F56-B60D-E3C7D30C954A

For a suitable macro, see Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks thread at:

http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html

or:

http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm

For Mac macro installation & usage instructions, see: http://word.mvps.org/Mac/InstallMacro.html