Macro to send email from Excel sheet through outlook

[saravanan1981]

HI,
I need macro code to send email from excel via outlook.
Task mentioned below.

I have a workbook with multiple sheets.
I want to email the sheet named as “ SLIP” as an attachment to those email ids mentioned in Sheet “EMAIL ID”
The sheet “EMAIL ID” contains “A” with ‘”To” email id’s and “B” contains “NAME”, “C” contains CC email ids and “D” contains “BCC” email ids.
The Sheet “Message Body contains” Message format to be in email.

So the email should be as below.

To: [email protected]; [email protected]
Cc: [email protected]
Bcc: [email protected]; [email protected]


Message body

Dear Mr.Savio/Mr.Peter/Mrs.Maria,

Please find attached qlip for your consideration
Please feel to call us.

Regards

Mark

Note: we may add delete email in respective columns time to time. Also the message body in the sheet also may change time to time.

[alansidman]

This link should be helpful

http://www.rondebruin.nl/win/s1/outlook/mail.htm

[dOOb]

Yup, needed something similar a while ago and that's exactly where i found it. Ron is the man!

If you are looking for a quick answer though, the below code should work assuming the following:
- you are using Office 2010 or later
- your Outlook Object Library is activated (check in Tools/References)
- your Outlook is running
- your "slip.xlsm" workbook is your active workbook when you run this code

I am aware that this code is probably poorly written, stuff was hardcoded, etc., but it should hopefully give you what you are looking for.

Please Login or Register  to view this content.