We have a workbook located on a public drive, which is often read and sometimes modified by company users. This workbook is also used by another individual without access to our company servers. This workbook is e-mailed to this individual at regualr intervals.

I've been asked to help create a method whereas the workbook is emailed automagically if a company user updates the file. Originally, I had a msgbox popup on Workbook_BeforeClose advising the user to email a copy if changes were made. Apparently, this was often ignored

I've found the .Sendmail function useful, and have been able to get it to work, however it has a few quirks. First, of course the Outlook warning pops up advising the user that an email is being sent on its behalf. There is no problem here, assuming the user allows the email to be sent. The problem is, if the user presses no for some reason, then an excel debug error is presented.

Also, I only want this email to be sent, if the user modified the workbook during that session. Many times a user will open the workbook to look at it only, and we don't want 10 emails sent a day, if no changes were made.

So what I need is a way to check inside the Workbook_BeforeClose function if the workbook has been modified, then send. Also would be great if there was a way to include a statement that would simply exit the function if the mailfunction call is aborted by the user.

Thanks!