| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
e-mailing a file from vba
I would like to have an excel file e-mailed to me after it
is saved by the user. I know how to set up for "aftersave", but I'm not sure how to set up the parameters for the e-mail part of it. Apparently you can't record a macro for that function, so I need to know how to set it in VBA. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
e-mailing a file from vba
Paula,
The following should work: ThisWorkbook.Save ThisWorkbook.SendMail ") For a lot more information, coding and examples, please see Ron de Bruin's site: http://www.rondebruin.nl/sendmail.htm John Paula Osheroff wrote: I would like to have an excel file e-mailed to me after it is saved by the user. I know how to set up for "aftersave", but I'm not sure how to set up the parameters for the e-mail part of it. Apparently you can't record a macro for that function, so I need to know how to set it in VBA. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
| I need to import my Excel Mailing list into mailing label format. | Excel Discussion (Misc queries) | |||
| How do I print mailing labels from an Excel file? | Excel Discussion (Misc queries) | |||
| mailing whole excel file as an attachment. | Excel Discussion (Misc queries) | |||
| I want to do mass mailing in outlook, from an excel file that has. | Excel Discussion (Misc queries) | |||
Linear Mode
