VB6 and mailmerge

Question posted by: Geoff (Guest) on March 20th, 2007 08:15 PM

Really not too sure what I am doing. I would like to launch MS Word from
VB6 so that it will mail- merge with a comma delimited text file called
Data.txt. The code below launches MS Word but how to invoke the merge from
VB .. don't know



Many thanks Geoff





Private Sub Command1_Click()



On Error GoTo Err_merge_Click




'Load the mail merge document as an object

Dim objWord As Object

Set objWord = GetObject("E:\Word\VB\Merge.doc")


'Make Word visible

objWord.Application.Visible = True



Exit Sub



Err_merge_Click:

MsgBox Err.Description



End Sub

Not the answer you were looking for? Post your question . . .
184,011 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).