Don't duplicate merged messages
I have a list of recipients (*.xlsm) which is added to daily. The intention of this list is for them to be sent a single (e)mailmerge about 4 days later.
I will eventually automate this, how do I make sure that Word doesn't re-email people every time the automation is run?
I'm imagining an extra (autofilled) column in the data source (attached) indicating mailmerge has been done on that entry.
The macro on attached spreadsheet can be denied access - it simply opens as a data input form.
Last edited by Fyldeboy; 02-28-2022 at 01:28 AM.
Reason: clarified needs
|