[UPDATE] Read Comment I have below for my final question. I bet this will be very easy for someone, as I now have the mail merge working fine. I just have one small problem
I have been trying to solve this for some time now but have been unable to come up with or find a solution. Basically, I have a VB 6 program I'm writing that when the user clicks a Command Button would open a mail merged document. To give an example of what I'm doing I created three files.
Basically I have a table in my database which contains a list of names. I have already created the template document and linked the data in word through the Original Document. My goal was that when the user click the Comman Button in the VB 6 app that it would take the OriginalDoc.doc and create the FinalDoc.doc by merging to a new document. It really doesn't have to save the final merged document, and infact if it just opened it that would be great, because the user could then save it themselves whereever they wanted.
So far I have had no luck. Below is the most recent code I've been working with. Can anyone assist me with this? Thank you very much for your time.
Below is my current VB Code
Dim WithEvents oApp As Word.Application
Private Sub cmdMerge_Click()
Dim test_app As Word.Document
Screen.MousePointer = vbHourglass
Dim Path As String
Path = App.Path & "\OriginalDoc.doc"
Set test_app = oApp.Documents.Open(Path)
.MailMerge.Destination = Word.wdSendToNewDocument
nes = True
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
Screen.MousePointer = vbDefault