Automatic email generation

[DavidLilley]

Here's a poser!!

I have developed a simple spreadsheet to record incoming telephone calls to
a maintenance response centre. As calls are received, they are recorded,
and depending upon the nature of the call, they are allocated to an
individual. I need to develop a system whereby the individual is notified
by email that a call has been allocated to them. Is there any way that by
updating an Excel spreadsheet, an automatic email can be generated??

Anybody's help appreciated!!!

David

 

[Frank Kabel]

Hi David
you can do that (for email coding see:
http://www.rondebruin.nl/sendmail.htm). You can add this code to a
worksheet_change event and create an email if a cell changes.

But to be honest I wouldn't use Excel for this. There should be some
cheap call management software systems in the market that are
specifically designed for this kind of usage