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

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

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.

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

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..

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.

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..

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