Macro to send an email automatically

J

Jenn T

I currently have a macro in Excel 2010 that automatically sends an
email to a specific person when a file is saved. Unfortunately some o
the the users of this file still have Excel 2007 and the macro does no
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 Su
 
V

Vacuum Sealed

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
Click to expand...
Check out Ron DeBruin's site, many examples of this...


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

HTH
Mick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending mail 5
Need to fix macro to send workbook via email 1
how to send an email when saving 1
Attaching files to Outlook 1
Sending Excel Workbooks to Outlook people automatically 1
AUTOMATICALLY SENDING EMAIL VIA A MACRO 1
Lose macros before saving 4
macro to automatically send an excel spreadsheet by email 1

Top