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

Attached Files

MoveOuts2.xlsm (24.7 KB, 9 views)