1. Did you just remove the line with the Quit? i.e. is the Set objWordApp =
Nothing still in there?
2. Maybe you also need to set cnn = Nothing. I can't remember what happens
in that case!
3. If you are still stuck, I can have another look, but I am probably near
the end of my ability to debug this one.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"justme0010" wrote in message
...
OK, I've tried out your code except I don't use the part where it exits
Word. I want Word to remain open because I want to still see the
envelope addresses but I just want the template part (main document)
closed. It still tells me the database cannot be opened around the 8th
execution (after 7 smooth executions). I dont know if its because of
not exitting Word but I would like to keep Word open until the user
exits it.
Yes, if worst comes to worst I will have to find a way to create the
main document entirely in code. Thanks again for the immense help.
--
justme0010