Can someone help me in writing a VB Script code to open a word letter template via macro in excel based on the conditions provided and then autofill the details required in the Word template based on the data on the same excel sheet...

I have a code for opening a word document, but when i use it it opens a word app without any details...

Sub Templates()
'
'
'
'Template
'
If Range("G6") >= 2 And Range("G13") >= Range("J13") And Range("D9") > Date Then

Dim objWord As Object

Set objWord = CreateObject("Word.Application")
objWord.Visible = True

objWord.Documents.Open "E:\Myself\RESUME\"""

End If

If Range("G6") >= 2 And Range("G13") >= Range("J13") And Range("D9") <= Date Then
Range("D13") = "Letter B"
End If

End Sub

Can someone please help me with this to understand how it works actually..