Opening Word Merge Letter with code....opens but no merge tool bar

  • Thread starter Thread starter Mike375
  • Start date Start date
M

Mike375

Guest
I have a merge letter with a query linked and also the normal merge fields...name, address etc. All works if I open the letter from Word. Two msg boxes.....selecting from table and about the linked data.

However, if I open the letter with code it opens straight away and by passsed the two msg boxes. The query updates OK.

But the mail merge tool bar on Word is greyed out. I have clicked everywhere but no go:D

Private Sub Label135_Click()
Const MSTB_MSWORD = 300&

Application.Run "utility.util_StartMSToolbarApp", MSTB_MSWORD

Dim docname As Object
Set docname = CreateObject("Word.Basic")
docname.FileOpen "c:\Letters\ExpMerg.doc"

End Sub
 

Users who are viewing this thread

Back
Top Bottom