this action cannot be completed because...

S

Shailesh Patel

Dear:
I get following error during mail merge and locks up vb program.
"this action cannot be completed because then other application is busy.
Choose 'switch to' to activate the busy application and correct the problem"
Please let me know solution.
Thank you for reply.

Shailesh
 
P

Peter Jamieson

Typically this occurs when Word is using an Access or Excel data source with
a DDE connection - in that case it has to start the Access or Excel program.
Several things can go wrong, e.g.
a. Excel or Access may be set up so that they do not accept DDE connections
(have a look at the Tools|Options for each program
b. Excel or Access may run a macro that prevents the connection from
completing, or display a dialog box which the user needs to respond to.
Sometimes these dialog boxes are not visible unless the user ctrl-tabs
through the available Windows. In particular, this would happen if the merge
data source is an Access parameter query.

There are other possible problems (e.g. DDE seems to be particularly
unreliable on some systems) but those are the ones I would look for first -
which version of Word are you using and what is the data source?
 

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