Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Macro - Copy - Email | Excel Worksheet Functions | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |