See attached

1 - Form amended to run SendMessage


2 - The process creates HTML messages, see the modified syntax used in the code. If you want to do it as you had it, you must collapse the range to its end before each new text or it will simply overwrite the last text.
3 - sName is just a variable name used to reproduce the FirstName in the message from the indicated cell.
4 - Added 5 days to delivery date
5 - Yes - remove the apostrophe to send the messages
I have added some annotation to the code.

Attached Files

MoveOuts2.xlsm (26.4 KB, 9 views)

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

Brilliant, incidentally, found your website to be so interesting

Now all working brilliantly, however, I'd like to add a html hyperlink into the generated message - would this be easy to do?