CreganTur
02-19-2008, 10:05 AM
I don't know if this is a VBA question or not, but I've got an interesting problem I need help with.
I've got an excel file of customer demographic information. I'm using a Mail Merge to merge this info onto a Letter, and also onto a custom envelope. That part works perfectly, but here's the issue:
I'm trying to find a way to set Word so that it will print the letter for Customer A and then the envelope for Customer A. Then it would print letter for customer B and envelope for customer B, ad infinitum.
Also the letter is standard 8 1/2" X 11" Portrait, but the envelope is 12" x 9" Landscape.
Is there a way to accomplish this programatically?:think:
I've got an excel file of customer demographic information. I'm using a Mail Merge to merge this info onto a Letter, and also onto a custom envelope. That part works perfectly, but here's the issue:
I'm trying to find a way to set Word so that it will print the letter for Customer A and then the envelope for Customer A. Then it would print letter for customer B and envelope for customer B, ad infinitum.
Also the letter is standard 8 1/2" X 11" Portrait, but the envelope is 12" x 9" Landscape.
Is there a way to accomplish this programatically?:think: