Send email if a condition is true.

[sn152]

Hi All,

I have a workbook which has data upto column N.

Column J has got the email IDs.
Column A has got the Item IDs.
Column M shows the age if each item ID.
Column N shows whether the age of item ID is greater than 1.

Now what I want to do is to send emails for the Item IDs which have the age greater than 1 to the respective persons email ids listed in column J.

If one email ID is working on multiple Item IDs only single email should be sent with all the Item Ids worked by that person.
Note: Email IDs might change everytime.

I have attached the sample workbook.
Please help me on this.

Thanks in advance.

 

[sn152]

Hi All,

Please help me on this.

Thanks!

 

[Nebu]

Hi:

Any outlook related queries you can get more response from the following forum
http://forums.slipstick.com/
This forum is exclusively for outlook.

Thanks

 

[sn152]

Hi Nebu,

This is more related to excel. Because I have all the data in an excel file. From there I have send email based on a condition. Thanks!

 

[sn152]

Hi All,

I have got a code that will send email according to the above criteria. But this will send multiple emails to same person, if the person there are multiple item ids worked by that person. But what I want is to send a single email with all the item ids a person is working on. Please help me. Attached is the updated file.

Thanks!