Edit and send Outlook email template .msg

P

pingme89

Board Regular
Joined
Jan 23, 2014
Messages
176
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

F
  • Question Question
VBA Send a formatted mail without Outlook
Replies
4
Views
719
Forsberg
F
R
  • Question Question
Send and email using an Outlook template
Replies
1
Views
565
Razor_Rob
R
L
  • Question Question
Skip Sending an Email If Status is Yes (already sent)
Replies
3
Views
226
Trebor76
T
E
  • Question Question
Send Range of Cells to Body Of Outlook 365 Without Crashing
2
Replies
10
Views
261
ExcelVBAnovice
E
A
  • Question Question
Sending Automated Emails with Attachments via Outlook
Replies
1
Views
251
Micron
M

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top