Bobby Heid
bheid at appdevgrp.com
Fri May 7 07:37:46 CDT 2004
Hi all,
I am creating a flat file from access to be used in mail merge initiated by
access. I basically create the flat file then load a pre-configured mail
merge document and do the mail merge.
The problem that I cannot figure out is how to have the column names in the
flat file but not have them show up as the first record.
Here's my relevant code:
Set objWord = New Word.Application
Set objDoc = objWord.Documents.Open(strMergeDoc)
objWord.Application.Visible = True
With objDoc.MailMerge
.MainDocumentType = wdFormLetters
'.OpenHeaderSource Name:=strDataFile, Format:=WDOpenFormatText,
ReadOnly:=True
'.opendatasource Name:=strDataFile, Format:=WDOpenFormatText,
ReadOnly:=True
.destination = wdSendToNewDocument
.Execute
End With
I tried using OpenHeaderSource to add a header file that has the column
names in it, but it seems to ignore it.
I added the following line to try to use the OpenHeaderSource function:
.OpenHeaderSource Name:=strDataFile, Format:=WDOpenFormatText,
ReadOnly:=True
Anyone have any ideas as to what I am doing wrong? I'm sure it is some
really easy, but U just can't see it. I did look through the archives, but
did not see what I was doing wrong.
Thanks,
Bobby