Pivot or CrossTab or Normalize or ?

I don't use mail merge. It is too hard to control. I use OLE automation and to show a "list", I create a table and insert the table. I'm in the middle of something. If you need an example, I'll post it later this afternoon.
Thanks. The formatting (list vs table) doesn't matter as long as the right and required info is presented in the correct area on the letter. I don't know how to use OLE automation (or don't recognize the term) so if you could post an example I'd appreciate it.
 
Re-reading this you appear to simply need your vendor information, the Pname and then All the related CNames separated by a CRLF as an output. This would give you a single record of data per page.

Vendor fields, PName , CName CRLF list in one field.
 
Here it is. There are two samples of how to use the dependents' data. Concatenated in a string - Pat, John, Terry or formatted as a table. The first would help you as Minty suggested if you want to stick with Mail Merge.
 

Attachments

Users who are viewing this thread

Back
Top Bottom