Open mail merged doc from VBA not working

[comptechbranden]

I use this code to open a mail merged word doc and it doesn't give me mail merge abilities. The doc does work if I open it manually from my drive. The difference is that when VBA in excel does it the document comes right up and when I do it manually a box comes up asking me to accept database data blah blah.

Sub open_word_2()
Set appWD = CreateObject("Word.Application")
appWD.Visible = True
appWD.Documents.Open Filename:="C:\path\filename.doc"
End Sub

There should be a code that lets word do its thing and open the merge box on open, right?

[comptechbranden]

accident post...

[comptechbranden]

Anyone know a solution for this?