[AccessD] mail merge from text file

John W. Colby jcolby at colbyconsulting.com
Mon Dec 22 06:34:35 CST 2003


I am finally doing the mail merge into Word that has been threatening for
the last 6 months.  What I have discovered is that if I specify a query
directly, Word opens a NEW instance of Access and opens whatever db the
query is in.  It happens that the FE the query is in has an opening login
screen etc. so that doesn't work too well.  Given that, I need to export the
data somewhere that word can get at it unencumbered.

Someone on the list suggested exporting the data to text files, then doing
the mail merge from those text files.  Can someone elucidate a bit there?
Is the text file comma delimited?  Does it need the bookmark name for where
each datum is going?  IOW what is the format of the text file going to be?

Any tips or tricks I should be aware of?

John W. Colby
www.ColbyConsulting.com




More information about the AccessD mailing list