Actually I am running the macro in word and accessing the excel application
through it. However I think I now know why the mail merge is bombing out and
I am getting weird error messages that have nothing to do with what is really
going on, it is an excel thing though so I will try there.
Thanks for your help
Heather

"Cindy M -WordMVP-" wrote:

Hi ?B?SGVhdGhlck8=?=,

I wanted to automate my mail merge and there is a problem it appears when I
am running my macro. I have accessed excel through word using late binding
and stored all the mail merge data into 2 excel tables (one french, one
english). I prompt for the english and french data files to use for the mail
merge. When running it for some reason I get an error about another macro
called personal.xls in my excel application stating the file is in use and
locked for editing.

If you're running this macro within the Excel environment, then you need to ask
this in an Excel newsgroup. To stop the people there from knee-jerking you back
here, mention the problem with the personal.xls FIRST, and in the subject line.
Then go on to say it's happening when you run code to automate Word, and post
the code. Don't forget to mention which version of Office you're using :-)

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 :-)