Email OnSave? searched Google, MSDN Blogs, MVPs & here w no result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SCrowley - 02 Aug 2007 19:34 GMT

Scenario:
Word 2007, WindowsXP: I create a Table of Contents (or any doc) and save it,
THEN, a person in my group modifies the document and doesn't tell me. I
create and print tabs that match the TOC I created only to discover that the
TOC or outline was changed which wastes my time and $$ for expensive direct
apply tabs. There are too many projects with too many people to effectively
'monitor' all the TOCs and outlines.

Solution:
Ideally, I would 'subscribe' to the document or programatically have an
alert sent to me anytime the document is modified. Is there a way to write a
macro to Send Email on Save or possibly another solution?

Signature

Thank you,

scrowley(AT)littleonline.com

Reply to this Message

Doug Robbins - Word MVP - 03 Aug 2007 03:26 GMT

If you create a macro with the name of one of Word's built in commands, that
macro will run whenever that command is used. In this case, name of the
macro that you would need to create would be FileSave(). Assuming that
these documnets for which you want to receive the notification are created
from a specific template, and that the user's machines all have access to
that template, then that macro could be created in that template and then it
would only apply to the save action on documents created from the template.
You would not want to receive an email any time that anyone saved any
document.

You can find some code for how to send an email message from Word in the
article

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Scenario:
> Word 2007, WindowsXP: I create a Table of Contents (or any doc) and save
[quoted text clipped - 13 lines]
> a
> macro to Send Email on Save or possibly another solution?

Reply to this Message

SCrowley - 07 Aug 2007 19:54 GMT

Thank you very much. I'll give this a shot and let you know how it turns out.

Signature

Thank you,

scrowley(AT)littleonline.com

> If you create a macro with the name of one of Word's built in commands, that
> macro will run whenever that command is used. In this case, name of the
[quoted text clipped - 30 lines]
> > a
> > macro to Send Email on Save or possibly another solution?

Reply to this Message