I have an access database with a list of client names. I have a VB program that i want to interface with a word doc to access a particular file and then mail merge with the names in the database.
I am using the code below to open the word doc from VB but how do i then get to merge the data from the database into the word doc??
Private Sub cmdCreateNewsletter_Click()
Dim objWord As Word.Application
Set objWord = New Word.Application
.Visible = True
.Documents.Open App.Path & "\news.doc"
Set objWord = Nothing
I was thinking I need to insert some more code somewhere?