E mail changes to a document to owner

[Kevbrad1]

Hi,
I am trying to find some code which will email the owner of a document to
tell them when changes have been made to it. Any help woud be most
appreciated.

 

[DaveLett]

Hi Kevbrad1,

Isn't it more efficient to not use a macro for this situation?

I think we'll need more background.

1) How do we determine who the owner of a document is? Is it part of
document properties? Is it available to the active document in some way?
2) How do we get the email address for this person? Is it also part of the
document properties? Is it available to the active document in some way?
3) Are you using Word's track changes? That is, if the number of revisions
in the document (by the current user) is greater than zero, is that the
trigger for returning the document? If there are other triggers, can you
elaborate?
4) Do you want the owner to receive almost "live" updates? For example, I
changed a word in the document, send it on? Or, do you want one person to be
working on the document for a couple of hours and then send the email
notification?
5) Are you attaching the document to the email message or it the document on
a network, a shared drive, or shared in some other way?

 

[Kevbrad1]

Hi Dave,

Thanks for your response.

1) The document owner (or the person needing prompting that changes have
been made) would be preconfigured depending on the document

2) I intended to put the owners email witin the code (if possible)

3) not sure about track changes as I dont have the skills / knowledge on
this, would have thought something that would be fired up on save possibly.

4) Yes I would like the owner to have an email as soon as changes are made.

5) Would not need to attach the document (which is held oon a shared network
drive)

Hope this is a bit clearer, and thanks again for your help.

Regards
Kevin

 

[Kevbrad1]

Hi Dave,

Thanks for your response.

1) The document owner (or the person needing prompting that changes have
been made) would be preconfigured depending on the document

2) I intended to put the owners email witin the code (if possible)

3) not sure about track changes as I dont have the skills / knowledge on
this, would have thought something that would be fired up on save possibly.

4) Yes I would like the owner to have an email as soon as changes are made.

5) Would not need to attach the document (which is held oon a shared network
drive)

Hope this is a bit clearer, and thanks again for your help.

Regards
Kevin

 

[DaveLett]

Hi Kevin,

<snip>I would like the owner to have an email as soon as changes are made.
</snip>
If you think about this for a minute, you'll realize that this just isn't
practical. For example, based on this description, you'd have to email the
owner for every keystroke. So, if you typed a new word that was 7-letters
long, the owner would get 7 email messages.

<snip>something that would be fired up on save possibly</snip>
That is probably a better approach. Have a look at the article "Intercepting
events like Save and Print" at
http://word.mvps.org/FAQs/MacrosVBA/InterceptSavePrint.htm

After that, have a look at the article "How to send an email from Word using
VBA" at http://word.mvps.org/FAQs/InterDev/SendMail.htm

HTH,
Dave