| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sending Email through a macro
I'm using the following in vbe for a particular workbook. I would like to be
able to key in a message or a subject before I actually send the file. I just want to have some control on the file being sent. Can this even be done? Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.SendMail Recipients:="recipient@address" End Sub -- Thanks a bunch! rojobrown |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending a group email | Excel Worksheet Functions | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Need a macro to Copy a selection and paste into a new email. | Excel Discussion (Misc queries) | |||
| How do I email an excel macro? | Excel Discussion (Misc queries) | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
