Send email if a condition is true.

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 automatically 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 person is working on multiple Item IDs only single email should be sent listing 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.

Hi,

Yes. I am using outlook.

Thanks!

Hi jaslake,

Thanks for your reply. But this code is sending emails to all the email id, even if column N is showing as False. But I want iot to send emails only if the column N is showing True.

Please help me on this.

Thanks!

Hi jaslake,

Yes it is generating 5 emails as you said. But what I want is it should generate email only for the rows for which the column N shows as "TRUE".

Please help me.

Thanks!

Hi jaslake,

I have a question. rows that have the status in column N as True, might change everday. In that case, will this code send emails only to the rows that have the status as True in Column N?

Hi jaslake,

Yes. But I have a problem here. For example, when the first 10 rows have the status as True in column N and all other rows after 10th row has the status as false in column N, still it is generating empty emails.

WOW. Super cool.. This works fine. Thank you so much jaslake...

Gents, please can you share the working file. I would like to apply the VBA code to my own worksheet if possible.

Many thanks,
Ken

(Excel Fiend)