automatic reminder

[Darwish123]

hello guys,
i'm somewhat new to excel and VBA
i have the following column

A
10/3/2012
13/2/2013
17/2/2013
5/9/2013

what i need
is to make a link between my excel file and outlook
and when the current date is before every date in column A by 1 month, i want to send to an outlook email popup reminder of a following description.

thanks in advance

[apo]

Hi Darwish...

Sending emails from Excel via Outlook is no problem..

Your post is slightly lacking in detail.. (the more detail the better)..
So .. correct me if I am wrong.. but i think you want the following:

Main Objective:
Loop through Column A and if difference between current date and date in Column A Row (x) is >= 30 days then email a Reminder..


To expedite your solution.. please provide the following:

1. Attach a sample workbook (or the actual workbook you are working on if the data is anonymised and the file size not too big)..
This saves me (or anyone else having to recreate what you already have.. hey.. we just want to add the code.. ... )


Things to make you solution better: (maye keep this in mind when creating your sample Workbook)..

* Who do you want each email sent to (what email address)?...
* What do you want each emails subject to be?
* What do you want the email body to contain? (you can add static text and dynamic info from your excel Workbook that relates to that email...)

Hope the above has somewhat helped in making you understand the needs and possibilities of a post such as yours..

[Darwish123]

ok
here what i have
the excel sheet is attached
what i want is that when every date listed in the excel file will be equal to NOW()+30 a reminder will be sent to my outlook account and the date in the excel file will be saved on my calender.

any help is appreciated
thanks