Automatic Mail

[shyam sundar]

Hi All

How to send automatic mail to a mail id when a cell value reaches a particular date.


For eg if a cell as a value 27 Jan 2013 then an automatic mail needs to sent to a mail id on 26 Jan 2013

can someone help me with this

[avk]

I have attach sample file. As per your requirement kindly make changes. If you have any format please submit sample file.

[ragavan.sridar1]

Hi Shyam,

Try this code, i got this code when i was in looking for an similar macro.


This needs to be entered in the Sheet where you have the dates.

Please Login or Register  to view this content.

Use the below codes in the module function.

Please Login or Register  to view this content.

[shyam sundar]

Hi sridar

The above code is working but only when i run the module. in my case i want an automated mail.

For eg customers buys a product need to pay the money with in 21 days in this case i want to sent a reminder mail to the customer on 20th day automatically

[shyam sundar]

Hi AVK

i dont know how to upload file here. This is my eg

customers buys a product need to pay the money with in 21 days in this case i want to sent a reminder mail to the customer on 20th day automatically.
If B cell as the date in which the customer buyed lets say D cell has the 21 date i need to send a reminder mail to customer. If the customer already paid no actions needs to be taken