Macro To Email XLS
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 |
Hi ynissel
See this page for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... 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 |
thanks ! Can I use the ActiveWorkbook.SendMail ", _
"This is the Subject line" to send to multiple users ? "Ron de Bruin" wrote: Hi ynissel See this page for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... 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 |
Yes
See http://www.rondebruin.nl/mail/tips1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... thanks ! Can I use the ActiveWorkbook.SendMail ", _ "This is the Subject line" to send to multiple users ? "Ron de Bruin" wrote: Hi ynissel See this page for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... 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 |
thanks !!
"Ron de Bruin" wrote: Yes See http://www.rondebruin.nl/mail/tips1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... thanks ! Can I use the ActiveWorkbook.SendMail ", _ "This is the Subject line" to send to multiple users ? "Ron de Bruin" wrote: Hi ynissel See this page for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ynissel" wrote in message ... 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 |
All times are GMT +1. The time now is 01:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com