Hello,
I created a mail merge word document, data comes from Excel.
When i navigate to Labels.doc and open it from Windows explorer, i get
prompted:

Opening this document will run the following SQL Command.....
Data from your database will replace existing data....

Which is what i want.

However, if i run the following code from Excel, the document opens,
but doesn't prompt me and it contains unrefreshed data.

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document

Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True
Set wrdDoc = wrdApp.Documents.Open("c:\labels.doc")

How can i force Word it to re-read/refresh the data when opening from
VBA?

thanks
Ron