josephemery
I have read through your problem twice now and I downloaded Kens kb entry that Dreamboat mentioned earlier in this thread. I have to tell you it sounds like the kb entry does exactly what you are trying to accomplish.



If you haven't done it I suggest that you download the example file that will be at the bottom of the kb page and when you unzip it, run the excel file and the BCMerge Macro that is in it. Be sure to leave the pushmerge.dot or template file in the same directory as the excel file. After you run it and you see the results, you can go to file-open and open the pushmerge.dot file to see how it is set up.



I apologize if you've already done that and are trying to do something different. If so it might help to upload a sample (you have to zip it up first) so some of the regulars in this forum can take a look at it. Be sure to remove any personal or proprietary info first.

ps. when you post code it makes them easier to read if you select the code and click on "add vba tags" from the format bar. I edited your vba in your post #4 in this thread as an example.