VB code for email alert/ notification in Excel 2007

**Rayees** · 07-11-2013, 04:41 AM

Heyy

I want to set email alert in mty excel sheet. ie, when a date ends i should get an email alert , Please help me how to do this.

**HaHoBe** · 07-11-2013, 12:46 PM

Hi, Rayees,

maybe the description on Send a mail when a cell reaches a certain value can help to solve the question on how to do it.

Ciao,
Holger

**Rayees** · 07-12-2013, 01:33 AM

Thank you , But its for one cell. What if the every cell have different values. for eg: based on the contract period. ie cell G2 have end period 01.01.2013 ( contract A), G3 05.02.2013, G4 10.05.2013 so on. So i want to receive the mail on each contract ends.

**HaHoBe** · 07-12-2013, 12:28 PM

Hi, Rayees,

the code can certainly be altered to fit but maybe it´s best to attach a small sample workbook with some lines of data which is similar to the workbook your working on (or post that after having desensitized the data).

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Ciao,
Holger