Macro to send email in outlook with predetermined message

N

neveu

Board Regular
Joined
Jan 27, 2009
Messages
225
hi all,
could anyone help me define a macro that would send automatically emails to a list of emails from a list in excel. for example all the email adresses are in column A, the subject in column B, the specific information in column C and the template message in column D

http://img52.imageshack.us/img52/387/20503693.jpg


thank you
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

J
  • Solved
Automatically sending email from a shared mailbox via an Excel macro
Replies
1
Views
874
Jeff Leubecker
J
V
  • Question
Excel for Mac 2021 v16.81. Send bulk email with an attachmen
Replies
2
Views
327
vk2023
V
E
  • Question
Excel VBA to Outlook Email Draft - How to save email draft copy to sharepoint / How to use template from sharepoint?
Replies
0
Views
366
elitef
E
D
  • Question
send an email notification when the value of the cell is selected in the drop down as Completed.
Replies
0
Views
286
danielz86
D
M
  • Question
Adding a link in email macro using a cell value
Replies
3
Views
115
KOKOSEK
KOKOSEK

Forum statistics

Threads
1,216,100
Messages
6,128,824
Members
449,470
Latest member
Subhash Chand

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