Automation of email sending from Excel...

Fester675

Board Regular
Joined
Sep 16, 2016
Messages
119
NAME (A1)
EMAIL (B1)
SUBJECT (C1)
TEXT (D1)
ATTACHMENT (E1)
Andy (A2)
ah@mail.com
Auto email
Dear (insert name) Andy
This is a sample of the body text to be included in the email message.
Signature
Attach PDF 1
Harry
hj@mail.com
Auto email
Dear (insert name) Harry
This is a sample of the body text to be included in the email message.
Signature
Attach PDF 2


<tbody>
</tbody>
Here is a sample of my Excel sheet. Is it possible to create one Command Button that will open Outlook, paste the email address (column B) in the TO field; the subject (column C) into the subject field; Text (D) into the main body, while inserting the recipients name; attach the file (E) and SEND?

So, for instance, I hit the button and for each individual row, there will be an email in Outlook generated, the TO/SUBJECT/BODY (including recipient's name)/ATTACHMENT all completed and sent from a particular/shared mailbox.

The real file will have approximately 200 to complete.

Thank you in advance!!
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,100,143
Messages
5,472,756
Members
406,836
Latest member
deeMD

This Week's Hot Topics

Top