Macro to send emails with different attachments and table in the email.

Hello,

Need a Macro in Excel 2010, for Sending send emails with different attachments and table in the email to list of user's in the Database.

For Eg.

Attachment Data

Code Name Email Address File Location / Name
1234 Temp 1 abc@xyz.com C:\Temp\1234
4567 Temp 2 def@xyz.com C:\Temp\4567

Mail body Data

Code Name Email Address
1234 Temp 1 abc@xyz.com
1234 Temp 1 abc@xyz.com
4567 Temp 2 def@xyz.com


1st Email will be of code 1234 with Specified attachment and Email address along with the data from "Mail body Data" in the form of Table in Mail Body (2 Count).

I am using the Data in 3 Different Sheets, Attached Sample.

Plz Help...

Thanks in Advance.
Aashish Shetty

Might require some editing to completely fit your needs

Please Login or Register  to view this content.

how can i add email subject and content from another column. Each email has a different attachment and different email content and subject