Email excel file automatically after update and save.

S

SAdam

New Member
Joined
Jul 10, 2015
Messages
6
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?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
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,
Code: 
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
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
Macro - Auto-email for monthly KPIs updates across all departments
Replies
2
Views
381
cwstudio2020
C
J
  • Solved
Files are all of a sudden taking forever to open and save
Replies
4
Views
1K
jaihawk8
J
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
548
Amo840812
A
W
  • Question Question
Macro - Auto-email for monthly KPIs updates across all departments
Replies
1
Views
194
whiteswan
W
O
  • Question Question
Auto email code
Replies
3
Views
219
Logit
Logit

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top