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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
|