Re: Email OnSave? searched Google, MSDN Blogs, MVPs & here w no result
- From: "Doug Robbins - Word MVP" <dkr@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 3 Aug 2007 12:26:52 +1000
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
"SCrowley" <SCrowley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:877FF5F6-904F-4117-AA49-C09C958628CE@xxxxxxxxxxxxxxxx
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?
--
Thank you,
scrowley(AT)littleonline.com
.
- Follow-Ups:
- Prev by Date: Re: Insert PageBreak before certain Styles
- Next by Date: Re: Array Question
- Previous by thread: Re: VBA code (Where does it live)
- Next by thread: Re: Email OnSave? searched Google, MSDN Blogs, MVPs & here w no re
- Index(es):
Relevant Pages
|