User From & EMail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 23 Jun 2005 17:29 GMT

Is there some type of code that I could put into VBA for a user form so that
when the user clicks "Enter" that an email is sent to someone letting them
know the excel file has been updated?

The form will be used within our LAN/WAN and we do have our own e-mail
server with SMTP capabilities.

Thanks.

Reply to this Message

Ron de Bruin - 23 Jun 2005 17:38 GMT

Hi Glenn

Try CDO (no security warnings)
http://www.rondebruin.nl/cdo.htm

More mail code
http://www.rondebruin.nl/sendmail.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Is there some type of code that I could put into VBA for a user form so that
> when the user clicks "Enter" that an email is sent to someone letting them
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message