Missing Something - Open Word Mail Merge from Excel but no data source

Hi All,

I have a very simple macro that will open a word mail merge doc from excel, however I can't get it to apply the data source.

When I open the word doc through word, it asks me to confirm the data source but when I use the macro it skips that step but also doesn't allocate the chosen data source.

I've searched on the forum and found several macros that will successfully open the document, but none apply the data source.

What am I missing??

Sub Open_Invoice()
 Dim objWord As Object
 
Set objWord = CreateObject("Word.Application")
 objWord.Visible = True
 
objWord.Documents.Open "P:\BUSINESS DOCS\Invoice.doc"
 
End Sub

Thanks,
Oz