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

On 26/04/2012 6:13 AM, Jenn T wrote:
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




Check out Ron DeBruin's site, many examples of this...


http://www.rondebruin.nl/sendmail.htm

HTH
Mick.