Sending mail to multiple users if they exceed the date

[Ashish_Bhatt]

Hi,

I have an excel sheet which has names of employees in one column, their respective email ID's in one column, date the task was assigned to them in another column and one more column which gives the date by which they need to complete the task. I have also added another column in my excel which will calculate the difference in dates (which is 10).

What I am trying is, if the date exceeds the time limit (which is 10 days), an email should be sent to that employee. This should happen for any employee who has exceeded the date (time of 10 days).

I have written few codes, which are not giving the desired results. I will share what I have and would appreciate your valuable inputs to get my requirement complete.

Please Login or Register  to view this content.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[HaHoBe]

Hi, Ashish_Bhatt,

you must change the column to hold the email-address which is put in as a constant here. I added a check for the validity of the email-address (untested though, no Outlook available on this computer for me):

Please Login or Register  to view this content.

Ciao,
Holger

[Ashish_Bhatt]

Hi,

I have attached the file for your reference.

Thanks!

[AB33]

Code copied from Ron de Bruin's site.

[Ashish_Bhatt]

Thanks a ton! Appreciate your cooperation.
I will implement it and get back to you with final results.

[Ashish_Bhatt]

Thank you!