"Geoff" <gfriar@freenetname.co.ukwrote in message
news:loSdnXDLLf59o53bnZ2dnUVZ8sGvnZ2d@brightview.c om...
Quote:
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
Quote:
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
>
>
"How to automate Word with Visual Basic to create a Mail Merge"
http://support.microsoft.com/kb/285332
You might find these articles useful...
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx
-ralph
