User From & EMail

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.

Hi Glenn

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

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


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


"Glenn" <[email protected]> wrote in message news:%[email protected]...
> 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.
>
>