How do I make a button that opens a prepopulated Outlook email message?
Posted on 2014-12-05
I need a button on a standard worksheet I use that opens up an new email message with the recipient, subject line and body of the message prepopulated.
The subject line I need is-
Loan Inquiry Packet, Cust Code: (code pulled from cell S3 in the same sheet the button is on; name of the sheet is NEW Inquiry)
In the body of the message, I need-
A hardcopy letter has been placed in your physical inbox, to be included with the packet.