help in automating sending of email from excel

[opxiii]

Hi, I would like to ask for your help with a problem of mine. I have a file which has a column that contains dates. what I need is when I open this file, excel will automatically look at the dates in the column and check if the date in the column is within 8 days from today. Let's say today's date is Jan 1 and the date in the column is Jan 5 so that means that the remaining days is 4 days up to Jan 5 and therefore within the 8 days. Once excel finds out that it is within 8 days it will automatically send an email to myself. I am not that good with excel. Thanks.

[dilipandey]

Hi opxiii,

Welcome to the forum.

What email you are using.. i.e., is it Outlook, Lotus ... ?

Regards,
DILIPandey

<click on below 'star' if this helps>

[opxiii]

Hi DILIPandey, i am using outlook. If there is a way to make it automatic so that when I open the excel file it will automatically calculate the dates and if the days are within 8days then excel will also automatically senda simple email to myself via outlook that this particular date is within 8days.. thanks in advance guys..

[dilipandey]

Hi opxiii,

Suggest you to look at following link where Microsoft site has better examples:-

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Regards,
DILIPandey

<click on below 'star' if this helps>