Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Macro to check for changes and e-mail results

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I need a macro that, on exit, checks for any changes, and, if they are found, e-mials a message to someone. Any ideas. Also, the macro must display the change in the e-mial. Thanks for your help.
 
this should get you started:

Code:
Option Explicit

Private Sub Document_Close()
  Dim oREV As Revision
  
  For Each oREV In ThisDocument.Revisions
    Debug.Print oREV.Type, oREV.Range.Text, oREV.Author
  Next oREV
End Sub

Private Sub Document_Open()
  With ActiveDocument
    .TrackRevisions = True
    .PrintRevisions = False
    .ShowRevisions = False
  End With
End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top