Oct 15 2021 10:25 AM
Office16 being used
Trying to open a MS Word Mail Merge file from within Excel. However, when the Word file opens I am only seeing the first record when I try to use VBA to open it. I am using the following to open the file;
Set wordapp = CreateObject("word.Application")
wordapp.Documents.Open "T:\Daily Pre-Trip Inspection Forms\Daily Pre-Trip Inspection Form - 709530.doc"
wordapp.Visible = True
What method am I missing? Why only one record not the ability to see any other of the documents within the MailMerge?
Thanks in advance for any help.
Oct 16 2021 07:08 AM