title: Run Word 2010 mail merge from access without query prompt
body: <p>My scenario is similar to that described in <a href="https://stackoverflow.com/questions/11301716/excel-vba-to-automatically-select-yes-when-prompted-during-mail-merge">excel VBA to Automatically select Yes when prompted during mail merge</a>, except that I am running the VBA from the Access database that contains the data to be merged, and (this may be relevant) the Merge is using a DDE data connection because the Query is a complex one and is not visible in by ODBC. I am trying to run a Word mail merge from an Access Run-Time Application which will be used by people who are not very computer-literate, so I want to avoid confusing them with unnecessary dialogs. The Answer to the previous question does, indeed, work for me, by preventing the prompt to allow the query to be opened, and everything else happens as it should, but the Merge returns a "no data source" error when the procedure hits the .Execute line. It appears that the query prompt is indeed suppressed, but the query is not opened.</p>
  
  <pre><code>' open the mail merge layout file
  objWord.Visible = True ' for now
  lngAlerts = objWord.DisplayAlerts
  objWord.DisplayAlerts = False
  objWord.Documents.Add strInFileName
  objWord.DisplayAlerts = lngAlerts
  
  With objWord.ActiveDocument.MailMerge
      .MainDocumentType = 0 ' wdFormLetters
      .Destination = 0 ' wdSendToNewDocument
      .SuppressBlankLines = True
      .Execute Pause:=False
  End With
  </code></pre>
  
  <p>Can anyone shed any light on this?</p>