I have an email template stored on the desktop, labeled Email.msg. The Email template is in HTML format.
I want to take a cell containing the recipients name from a cell in Excel and adding the name to the Email template. I have put a placeholder in the places where the recipients name should be inserted. I put in "@@@NAME@@@" as a placeholder.
How can I use VBA to replace "@@@NAME@@@" in the template and send it out with Outlook?
I am using Excel 2013. My OS is Windows 10. Can anyone help me?
Thank you in advance.
I want to take a cell containing the recipients name from a cell in Excel and adding the name to the Email template. I have put a placeholder in the places where the recipients name should be inserted. I put in "@@@NAME@@@" as a placeholder.
How can I use VBA to replace "@@@NAME@@@" in the template and send it out with Outlook?
I am using Excel 2013. My OS is Windows 10. Can anyone help me?
Thank you in advance.
