Slow performance when editing mail merged document after vba automation

R

Rosie

The problem:
A MS Access application that takes data from the database and mail
merges it with a MS Word document. This works fine except when the
user tries to edit the resulting mail merged file. MS Word's response
is EXTREMELY SLOW. The user types in a single character and needs to
wait about 30 seconds before it appears on the screen. Word seems to
be busy doing something but I'm unable to determine what.

The details:
It looks like this problem only exists when the mail merge
template just contains a table which contains mail merge field codes.
If you open the mail merge template from within MS Word and then mail
merge the file manually using a MS Access database as the data source,
the response time is fine.

I'm using Office XP to develop both the MS Access database and the
MS Word mail merge template. The vba automation from MS Access uses
ado and uses a "select * from table" query as the data source. I'm
also using the API calls documented at "The Web Access",
http://www.mvps.org/access/api/api0001.htm, to prompt the user for the
name of the template file.

Does anyone have an idea of what is happening?

Any help would be appreciated.

Thanks, Rosie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top