Excel Database + Word MailMerge

[smallxyz]

I have a Excel database with records, and a Word file with a customized template.
Upon the opening of the Word file, the Excel data are required to connect to the Word and execute mail merge.

The code below works well and is inserted into the Word 's Module.

'   [ Doc_Open ]
Private Sub Document_Open()
    '------------------------------
    With ActiveDocument.MailMerge
        .Destination = wdSendToNewDocument
        .SuppressBlankLines = True
        With .DataSource
            .FirstRecord = wdDefaultFirstRecord
            .LastRecord = wdDefaultLastRecord
        End With
        .Execute Pause:=False
    End With
    '------------------------------
End Sub

However, it always prompts the user to select the Excel path during start.
As the path of that Excel file is always fixed, how to amend code such that, during the next file opening, no path selection is required?

Thanks !

 

[mole999]

Maybe > how to use a relative path to a data source for word mail merging (word 2007, word 2010) – alexsapps.com programming blog

 

[smallxyz]

Thank you, mole999!
That's a great help!

 

[Macropod]

Cross-posted at: Excel Database + Word MailMerge
Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html