| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro to send an email automatically
I currently have a macro in Excel 2010 that automatically sends and email to a specific person when a file is saved. Unfortunately some of the the users of this file still have Excel 2007 and the macro does not seem to be working for them. Any thoughts?
Here is what I am currently using: Private Sub Workbook_AfterSave(ByVal Success As Boolean) ActiveWorkbook.SendMail Recipients:=Array("email address"), Subject:="New Job" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to automatically send an excel spreadsheet by email | Excel Programming | |||
| Macro to send email automatically. | Excel Discussion (Misc queries) | |||
| Macros to send email automatically | Excel Programming | |||
| automatically send email in excel based on value/macro guru stuff | Excel Programming | |||
| automatically send email from excel | Excel Programming | |||
Threaded Mode
