Email excel file automatically after update and save.

[SAdam]

Hi, I looked around and could not find. Is there a way for excel to automatically email the file after it has been updated and saved while on a network drive?

 

[Fazza]

see the first link at this page of Ron de Bruin's great site https://www.rondebruin.nl/win/s1/outlook/mail.htm

https://www.rondebruin.nl/win/s1/outlook/amail1.htm

Not sure if you need more help than that?

If so, in addition to adding Ron's code to your file add this to the file's workbook module,

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Call Mail_workbook_Outlook_1
End Sub

Please modify the above as required to do what you need. cheers

PS You may prefer one of the other versions Ron offers. That is Mail_workbook_Outlook_2 or Mail_workbook_Outlook_3