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.
Please help me on this.
Thanks in advance.
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.
Please help me on this.
Thanks in advance.