| 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) | |||
Linear Mode
