Auto mail merge of word file using vba code

[Tarek_CTG]

Dear All,

I have a below code to open an existing word file. The word is mail merged to a different excel file. I just need to open the word file, and automatically it will be mail merged with excel file, and open the new output word file and autosave it.

Option Explicit
Sub OPENWORD()
Dim WD As Word.Application
Set WD = New Word.Application
WD.Visible = True
WD.Activate
WD.Documents.Open ("C:\Users\Tarek\Desktop\Employee Profile.docx")
End Sub