Quote:
Originally Posted by macropod
The issue you're running into is most likely due to the documents concerned being mailmerge main document. You could insert:
wordApp.DisplayAlerts = wdAlertsNone
before:
wordApp.Visible = False
to allow processing to continue but be aware this breaks the mailmerge data connection, which would have to be re-established before the documents could again be used for a mailmerge.
|
Hi, Paul, and thanks. I tried this, but I didn't think that would be the case, as these old files are not made with mail merge. Many of them were before I started, and I don't think anyone knew how to mail merge here.
But I gave it a shot. And at first, I got a "waiting for an OLE object in another application" error and I thought nothing was happening. Then, the Compress Pictures dialog popped up. (One of the limitations of this in Word is that there is apparently no good VBA bypass for picking "all pictures in the document" and "web quality" vs "print quality", etc. It did eventually work. Despite the fact that I have to be attendant and click those boxes/radio buttons (some are .doc and some are .docx, depending on how old they are.)
Once again, to my VBA rescue! Thanks again, Paul.