Quote:
Originally Posted by gmayor
The obvious solution is to use the last column of your sheet to indicate whether the message has been sent. This can be automated from the macro that sends the messages - see attached
|
Thanks so much, I had intended sending the (e)mailmerge document as a html document via word 2016
[review.docx] (though I do have outlook 2016 available) simply because I have used Word for mailmerge in the past. Would your macro be alterable to allow that? And could I add an extra final line into the macro to [send] the email(s), so no further intervention than clicking the button on the spreadsheet?