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
|
Some questions, so I can learn
I think the modified workbook attached opens with a Userform, I'd like to run your code from the "save and send" button on that but at this moment can't get the SendMessage() sub to run from it?
Looking at your code with the intention of using Outlook, I see that BodyFormat means I can send the emails as HTML. Does that mean I can use just simple html in the code?
I can see the merge fields like
"sName" - interested that doesn't match any of the column headers on the spreadsheet, so if I wanted to use the 'STAFF' column, how would I format that?
Can you tell me, where in the code it indicates send > 5 days after the 'date' column
And finally . . .
I assume that after testing, I need to remove the apostrophe at the start of
'.send