Need a Macro to send email from excel through Outlook basis of different conditions

Hello Guys,

I need help in creating a macro to send email from excel through Outlook basis of different conditions and with embedded text and subject.

There 2 workbooks attached with this post. The workbook named “Data” contains the data and the workbook named “Emails” contains the Dealer Names (in Column A), the Email ids of the contact person (Column B, C and D), the subject (in Column E) and mail content (in Column F).

I need a Macro which first split the data basis of “Dealer Name” Column F into multiple sheets from “Data” sheet. Now, each sheet will contain only the Individual dealer’s data. The data whose ageing is 2 or more than 2 days (in Column H) is highlighted in yellow.

Now, I need to send a separate email to dealers with their data details from range A to F (including headers) as an embedded text with subject and mail content which is present in “Emails” workbook.

Now the twist is, if any dealer having the Ageing value in Column H is 2 or more than 2 days (highlighted in yellow color) than the email should be sent in CC to Column D email ids but if there is no Ageing more than 2 days than the email should be sent in CC to Column C email ids.

“To” email ids (in Column B), subject (in Column E) and mail body (in Column F) will remain same in both conditions. Column A is containing the Dealer Names through which macro will identify the email ids.

If you need any more clarification than please let me know.

Any help will be appreciated.

Thanks,
MG

Check out Ron DeBruin's site - loads of great code on there for e-mailing through Excel

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

Hello estratosphere,

Thanks for reply.

I had checked the link. There are good macros available.

Perhaps, the problem is there is no code available which check the values of Column H of every sheet before sending (whether it is greater then 2 or not) the email and decide the CC email ids.

If ageing of case is older then 2 days than Macro should pick the CC email id's from Column D else the CC email id's will be pick from Column C.

Please let me know if you something on this also.

Thanks,
MG

A simple If..Then..Else statement should be able to do that for you.

Please Login or Register  to view this content.

Something along those lines - with your cell references etc in it

Try this

Data(1).xlsm

with this macro (I've already put the macro in for you)

Please Login or Register  to view this content.