Thread: [Solved] Troubleshooting Excel VBA performing Word operation
View Single Post
 
Old 09-22-2025, 11:09 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,465
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote