When this is run it works great.
UNTIL they start it and have a word document open.

it runs but the output is not there.
I understand that and only run my mail list when i DO NOT have a word
document open.

they have taken this at my work and gave the database to another
person. They run it and then shout crap code and everything else even
after being told to close any word documents before running it.

is there a way around this?
Can it be used while other word documents are open, I could not find a
way to do this.

Is there some way to check and see if any word documents are already
open and refuse to run and/or warn the user?

"sparks" wrote in message
news:2fl2s6t6j42cd6hu09j6kogptipi15mjov (AT) 4ax (DOT) com...

As a general rule, they should be able to have as many open documents as
they please.

I assume the command you are using in a form is:

MergeSingleWord

You might want to mention if there is some other detail you are leaving out,
or perhaps you are doing something different here.

You could and should also try download the latest version, and try the test
download, and see if that works.

http://www.kallal.ca/msaccess/msaccess.html

In above, scroll down to the super easy word merge.

So, as a general rule, they should be able to have many documents open, and
even documents that have nothing to do with the merge should not be
effected.

I not modified that code in some time, but I do often make some changes over
the years.

It not clear how old of a download copy you have, but try the above sample
nd see if it allows more then one document open, it should.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com