N newtoVBA502 New Member Dec 21, 2022 #1 I have data set with the name of employees and other information, I would like to write a macro that take every name and plug it in a templet in word then saves that word document with the name used
I have data set with the name of employees and other information, I would like to write a macro that take every name and plug it in a templet in word then saves that word document with the name used
M macropod Member Dec 26, 2022 #2 You could automate a mailmerge from Excel to do that. For the required macro code, see Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks page at: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html For the mailmerge basics, see: Use mail merge for bulk email, letters, labels, and envelopes - Microsoft Support
You could automate a mailmerge from Excel to do that. For the required macro code, see Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks page at: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html For the mailmerge basics, see: Use mail merge for bulk email, letters, labels, and envelopes - Microsoft Support
