Automated E-mails from Excel

Hi,

Does anyone know how can I write code which will generate an e-mail with fixed amount of text when certain information is entered into an excel spreadsheet?

What I have is a list of incidents (e.g. type of crime/ disorder), a post/zip code of the location it took place, and details of what ward it took place in.

I would like to set something up whereby when say 5 incidents occur within a ward in a one month period, an automated template e-mail is sent to the councillor/ community leader of that ward to notify them of the problems.

I have attached a small scale template workbook of what I mean for a visual explanation, any help would be hugely appreciated, I'm a novice with VBA, I know there is a way but don't know how to get there!!

Many thanks.

Hi Excel_Ant,

Have a look on Ron De Bruin's stie here: http://www.rondebruin.nl/sendmail.htm

There is more info on sending emails from excel than you could ever hope to need

Add this to the Graffiti worksheet code module

Please Login or Register  to view this content.