Send email Criteria Match then

[Abhijeet]

Hi
I have excel data i want to send Email to Particular department I have mention in column L If Column H to J if any data then how message Body part will reflect and send email to that Department.Please give me macro for this

 

[Abhijeet]

Please help me in this and give me macro for this

 

[Hui]

Abhijeet

If you goto the Main Chandoo.org Site and using the Search Box with "Send Email with conditions" you'll see many posts related to this:

http://forum.chandoo.org/threads/automatically-send-email.14705/
http://forum.chandoo.org/threads/send-email-if-criteria-is-met-in-excel-to-outlook-recipent.15482/
http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/
http://forum.chandoo.org/threads/need-vb-code-to-send-email-message-based-upon-sheet-criteria.3811/

I'd suggest you start with these and come back for specific questions

 

[Abhijeet]

Hi
I have problem how to extract data of i have mention in Column L.please tell me that

 

[Abhijeet]

Please give me macro for this i am stuck how to pull data i have mention in excel file Column L in Body of The message please help me

 

[NARAYANK991]

Hi Abhijeet ,

Suppose the email has to go all 3 departments ; what will the body of the message be ?

Can you take any one trust example , and manually type out the message body for each of the 3 departments ?

Narayan

 

[Abhijeet]

Hi Narayan
This is message body like this
Hi

From Trust 106 Department 1,Department 2,Department 3 Data is not Updated So Please Update Today Itself

Thanks,
Abhijeet

 

[NARAYANK991]

Hi Abhijeet ,

Does this mean that if a message has to go to more than one department , the message will be the same to all the departments ?

Narayan

 

[Abhijeet]

Yes

 

[Sathish KV]

Hi,

Have a stuctured data to send automated mails

Refer attached file where the respective data to be updated and macro to be run

 

[Abhijeet]

Hi sathish
Thanks for this but i want pull message i show in column L plaese tell me how to pull this

 

[Sathish KV]

Hi,

You have entered some manual entries in the column L. Do you need a formula for this

 

[Abhijeet]

if in macro possible then give me macro or formula but that can reflect to ur email macro and send essaily

 

[Sathish KV]

Hi,

Try the below formula in cell L2 and drag down

=TRIM(SUBSTITUTE(IF(AND(H2="",I2="",J2=""),"","From Trust "&A2&" "&H2&", "&I2&", "&J2&" Data is not update so please update today itself"),", ,",","))

 

[Abhijeet]

Hi
I have mention Email Id in this file

 

[Sathish KV]

Hi,

Check out the attachment

 

[Abhijeet]

Hi
Above Macro Run then show like this
Hi,,

From Trust 100 Department 1, Department 2, Department 3 Data is not update so please update today itself

So please update today itself.

Thanks

In VBA Code mention the Mail ID & Subject i want in excel mention the ID & subject line those goes in to Email & In Single Mail i want send not Trust wise what ever In Column L goes in to Messag Body

 

[Sathish KV]

Hi,

According to the attachment can you draft a sample mail in notepad and upload it

 

[Abhijeet]

Hi
In this attach file show how mail looks like.To: CC: Subject: mention in excel those id send the mail