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