Hi All,
I have a problem with a mailmerge, but believe it to be more Word/Windows based than mailmerge.
Anyway, I have two sites where Word 2002 and Word 2003 are being used.
At both of these sites I have deployed a mailmerge Word document that runs a macro to poll for incoming data source files. These data source file are text files that are generated by an external system. Once a data source file is detected the macro opens up the mail merge template file and does a mail merge with the data source file, and then saves the result. As a note, this setup requires that we link the mail merge templates with default data source files (also text files).
Somewhat recently at the sites this process (which works at various other sites) has been reporting that during the mail merge process that either the default data sources text files or the data source text files cannot be opened. When this has happened the following tests have given the following results:
a) Immediately going to the directory where the "missing" file is located proves the file is present
b) The "missing" file can be opened via notepad under both same and additional Windows session
c) The "missing" file can be opened via Word under both same and additional Windows session
d) Re-opening the mail merge template can open the default data source file claimed to be "missing"
e) RE-opening the mail merge template and manually performing the mail merge can use the data source file to be "missing"
f) Closing the mail merge template and reopening can open the default data source file claimed to be "missing"
g) Closing the mail merge template and manually performing the mail merge can use the data source file to be "missing"
h) Continuing the macro by debugging and re-stepping through the mail merge macro can use the "missing" file and use it in the mail merge
i) Immediately restarting the mail merge by closing the main macro document and re-opening can now use the "missing" file
Further to this, there is no consistency in which files are claimed to be "missing".
Currently this is only happening at two sites out of over 20, and I'd hate to start recommending my clients move to a non Office alternative, but I'm quickly approaching the opinion that neither I or anybody else can do anything about this issue.
This is a re-written re post from http://groups.google.com.au/group/microsoft.public.word.application.errors/browse_thread/thread/799f7d7f1031f6de/3ad5ef2be2cbcc2d?q=#3ad5ef2be2cbcc2d
Would appreciate anybody's thoughts or ideas about this.
TIA
Eugene