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.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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