Paul, I'm back at it this morning...trying not to pull my hair out. I'm having trouble with a couple of things:
1. Getting all order information per company on the same list/page. It's creating a page per order.
2. I can't figure out how to format the fields so that the data merged in lines up under the column headings. The data is just all jammed together without the desired tabbing.
I attach the documents; maybe you can take another look and see if you can tell what I'm doing wrong? Note that I added a field of 'Item' to the spreadsheet.
John
EDIT: In addition to these fields, I want insert these additional fields before the repeated data: 'Address_1', 'Address_2' (most often will be blank), 'City', 'State', and 'Zip'. They are of course not in the attached documents; I attempted to build another MailMerge file and related spreadsheet this afternoon, but Word kept bombing on me...so I'm going to take a much-needed break from this for a bit and go have a short, healthy cry....
ACCO template_2.doc
Test dbase_2 0312.xls
ACCO template_2 merged.doc