View Single Post
  #7   Report Post  
Plucky
 
Posts: n/a
Default

I have no trouble creating a "flat file",

my problem is, i want to create a mail merge that will merge to 300 people,
and each person has a list of items from the database that need to be
displayed.

so if i outerjoin the person's record to their list of 15 items, i would
have that person's name in 15 records.

Seems like mail merges are only meant to use 1 data source...so i'm thinking
i just need to use ADODB to connect to SQL and just put the data on 300 pages
recursively.

Does this sound like a messy solution?

Thanks,
JP