Macro To Email XLS

ynissel · May 25, 2005

How do I create a macro to Email the current file to a specific user as an
attachment ? Can I insert this at the end of an existing macro ?
Thanks

Ron de Bruin · May 25, 2005

Hi ynissel

See this page for examples
http://www.rondebruin.nl/sendmail.htm

ynissel · May 25, 2005

thanks ! Can I use the ActiveWorkbook.SendMail "[email protected]", _
"This is the Subject line"
to send to multiple users ?

Ron de Bruin · May 26, 2005

ynissel · May 26, 2005

thanks !!

Ron de Bruin said:
Yes

See
http://www.rondebruin.nl/mail/tips1.htm