You have some objects (fields or OLE) with the AutoUpdate property set to True.
You may try something like this before saving the doco for email:
For Each s In yourDocObject.Shapes
With s
If .Type = msoLinkedOLEObject Then
.LinkFormat.AutoUpdate = False
End If
End With
Next s
For Each f In yourDocObject.Fields
f.LinkFormat.AutoUpdate = False
Next f
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.