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