Re: Access Automation Mail Merge
From: Cindy M -WordMVP- (C.Meister-C_at_hispeed.ch)
Date: 11/22/04
- Next message: Lars F. Jørgensen: "Open Hyperlink in new window fra Excel"
- Previous message: gopal: "Urgent "setup.exe" doesn't install the packaged files"
- In reply to: IHNW: "Access Automation Mail Merge"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 22:20:06 +0100
Hi =?Utf-8?B?SUhOVw==?=,
> I've noticed that if you link a datasource directly from Microsoft Word the
> merge is relatively quick. Unfortunately, using automation from Access with
> large recordsets in excell of 1000 records can take a while to open Word and
> start merging the records. It may have to do with Spell-check or other
> various tools that are running in Word? Is there a way to speed up the merge
> process using automation from Access?
>
Generally, automation is slower from an outside application. If Access is
running things, most likely it's also creating an instance of Word? And then
opening a document? Is your code also linking in the data source?
All these actions take time; and things that have already been finished when
you tell Word in the UI to execute a merge.
And are you certain you're using the same connection method in your code as in
the UI? The connection method can also affect the speed with which a mail merge
is processed.
You also need to realize that Word gets slower and slower, the more records you
try to merge. And the slow-down is not linearly proportionate, as you'd might
expect.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
- Next message: Lars F. Jørgensen: "Open Hyperlink in new window fra Excel"
- Previous message: gopal: "Urgent "setup.exe" doesn't install the packaged files"
- In reply to: IHNW: "Access Automation Mail Merge"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
