Automatic email based on date
 

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.

Automatic email based on date
 

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.

Automatic email based on date
 

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.

Automatic email based on date
 

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.