See
http://www.rondebruin.nl/mail/prevent.htm
Outlook 2007 or CDO is the best way
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Excel Help!" wrote in message ...
Great example. How do I turn off the warning notice?
"Ron de Bruin" wrote:
Hi Excel Help
Start here for a Outlook example
http://www.rondebruin.nl/mail/folder3/message.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Excel Help!" wrote in message ...
I'm searching for information to complete the following task: I have an excel
file which contains the following information. Column A: Name; Column B: Date
training completed; Column C: email address. I would like to write a macro
to search thru column B for an date, if there's no date, it would send an
email to user's email address in colum C? It's bvious I would need the macro
stop if there no name in Column A. Thanks in advance.