How to create an automatic email alert when excel datas reaches the particular expiry date

[raji123]

How to create an automatic email alert(Outlook 2007) to multiple employee before 30days when excel2007 data's reaches the particular expiry date

[apo]

Hi.. As you provided very limited details.. here's a solution that you should be able to adapt..

If you had provided more details in your initial post.. then a solution more tailored to your needs woudl have been forthcoming..

Please Login or Register  to view this content.

[raji123]

hi thanks for your reply .. I checked the sheet but i require an automated sheet for eg: Start Date End Date Customer Name: Part No: Description Quantity: Serial No: Alert date
29-11-2012 29-11-2013 sgdsgsgs fggsfdg fgnslgmsl ankfkdfdfsdf 29-10-2013
19-11-2012 20-11-2013 20-10-2013
09-11-2012 11-11-2013 11-10-2013
30-10-2012 02-11-2013 02-10-2013
20-10-2012 24-10-2013 24-09-2013
10-10-2012 15-10-2013 15-09-2013

[apo]

Upload a sample Workbook.. maybe i or someone else will apply the code to it..

Like i said.. you provided next to no detail son your initial post..

[raji123]

Pls find attached , i want the datas named serial number ,customer details start and end date in the email body to alert employees through mail(outlook 2007) automatically without opening the excel sheet.

[apo]

to alert employees through mail(outlook 2007) automatically without opening the excel sheet.

mm.. not sure you can do that... I mean.. the Workbook would have to be opened to run the code..

I have just added a button to run the code.. but you could put the code in the Workbook_Open event so it runs automatically as soon as the Workbook is opened..

You didn't have the email addresses for the employees.. so i added them to Sheet 2 (A2 down)..

The email body now contains the things you wanted... you should be able to adjust things to suit if needed..

[raji123]

Thank you so much... it works!!!!!