|Let me start by saying that we don't get a lot of Word macro questions in this forum and that AFAIK there are no Word macro experts that hang out here.|
I can help with Excel macros but I'll toss out a suggestion or 2 anyway...
re: "1. Merge the letters as usual, then running a macro that devides the letters up into individual printing jobs and sending those to the printer. This did almost Work, but the individual printing jobs did get mixed up and some jobs didnt get to the printer, so this is not the way I want to go."
Nothing personal, but my guess is that there is a problem with the macro and that this might be the best way to go. Without seeing the code, it's hard to say what is going on. We've all seen some strange things happen with VBA code, so maybe that approach won't work, but it seems like the easiest. Perhaps if you share the code it might be something we can look at/test.
re: "2. Merge the letters as usual, then running a macro that changes the section breaks from NewPage breaks to OddPage breaks. The theory of this (as far as I know) is that when you replace the newpage breaks with the oddpage breaks on and odd numbered page, then Word inserts a blank page after that page, so that the switching between odd and even page numbers continues. The macro I have tried was this:"
Again, not being a VBA for word expert, I'm not sure if this will accomplish your goal, but the error can be eliminated by changing the following instruction from:
.SectionStart = wdSectionBreakOddPage
.SectionStart = wdSectionBreakOddPage - 1
Just a guess, but maybe Word wants all "OddPage Section Breaks" to actually occur at the end of the previous even page.
If that doesn't help, you might consider this news group, which is dedicated to Word:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.