excel 2007 automatic email notification

**Jayrene** · 02-27-2011, 03:16 PM

Hi, I need a help here. I have a workbook and I want it to send email notifications automatically when a contract is due for renewal (45days before expiry) and again on the date it expires. I've seen a couple of posts/questions here same as mine and I tried to the same but I always fail. I can't run it. I'm using outlook in the office. I attached my sample workbook. Thanks in advance.

**john55** · 02-27-2011, 03:51 PM

wrong expl.
sorry

**royUK** · 02-28-2011, 05:57 AM

If you do a search there's several answers to this question. You should be able to adapt Ron de Bruin's code

**Jayrene** · 02-28-2011, 01:00 PM

thanks very much. I'll try this.

**Jayrene** · 03-01-2011, 09:52 AM

I'm so sorry if I'm really dumb on this. I can't figure out how to do it. To be clear on my requirement this is what I need my workbook to do. It should send out an email notification automatically that says "Contract is due for renewal" once a cell in column "L" reaches the value of "-45" and again once it reaches the value of "0" it will send an email that says "Contract expired" and should get the Vehicle ref no. set in column "B". It should pick-up email address set in column "S" and returns the email send out date in column "R". Hope these are all possible so to make my life easy as I have loads of these and I currently doing it manually. Thank you...

**Jayrene** · 03-09-2011, 08:03 AM

Hi. I really need a solution on this. I haven't done it up to now. I tried doing it but no success. Could someone help me please.

**somdeb2009** · 05-29-2012, 12:57 AM

Hai,,I have registered here today, I have read your comments & seen ur sample excel file, but if any help u get for automatic email notification to specifics ids when any one open the excel file. I am unable to do that.

**john55** · 05-29-2012, 01:59 AM

hi somdeb2009,
Welcome!
Please be so kind and open your own thread!

**arlu1201** · 05-29-2012, 02:56 AM

Somdeb2009,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.