Mail merge data source lost when opening document with Macro

Hi

I am using a simple macro to open a word document from excel. The document contains a mail merge to run on records defined with a check box in the workbook, which works fine when opened independantly.
When i use the macro in excel to open the mail merge the SQL comand to link the data source does not run and defaults to blank

any help would be appreciated!

thanks

my macro:

Sub Confirmemployment()
Dim WdApp As Object, WdDoc As Object

Set WdApp = CreateObject("Word.Application")
WdApp.documents.Open "\\athfile1\2005$\PERSONNEL\OROM Jersey\OROM templates\Confirmation of Employment.docx"
WdApp.Visible = True

End Sub