Run-time error '5922' - Mail Merge

[dirtychinch]

snb, can you think of any way to name the word document automatically, or at least give it a name other than "Letter1"?

Edit: just remembered why I do the savecopyas, and kill. The problem I had is that when someone is doing the mail merge, they could be on any computer in the building, or any excel document that they're working on could be stored anywhere at all. This makes it impossible to link the word template to the document properly. So, I just made the destination of the file fixed, by using this temp file, thereby preventing any problems with determining the file location. It works brilliantly I do the kill just to clean up afterwards.

Edit2: Just found this, and I'm wondering if perhaps it can be adapted to work from Excel to Word:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=122

I'm yet to look into it properly, but it's food for thought.