Microsoft Office Forums - View Single Post - Auto generate new mail with attachment

Thread: Auto generate new mail with attachment

View Single Post

Old

03-06-2023, 01:07 AM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2019

gmayor uses Office 2019

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,106

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

If you have 20 recipients, mail merge would make sense. Assuming each employee has a different variation of the worksheet then you could use E-Mail Merge Add-in to merge to e-mail with the filenames and recipients taken from the datasheet.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote