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

S

SCrowley

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?
 
D

Doug Robbins - Word MVP

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




--
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
 
S

SCrowley

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

scrowley(AT)littleonline.com


Doug Robbins - Word MVP said:
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




--
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
 

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

Top