Pivot or CrossTab or Normalize or ? (1 Viewer)

tanyamc

Registered User.
Local time
Yesterday, 23:32
Joined
Mar 7, 2019
Messages
43
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.
 

Minty

AWF VIP
Local time
Today, 05:32
Joined
Jul 26, 2013
Messages
10,355
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.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 01:32
Joined
Feb 19, 2002
Messages
42,981
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

  • SampleWordAutomation_20210314.zip
    306.1 KB · Views: 73

Users who are viewing this thread

Top Bottom