Converting Multi-Record to Flat Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a quarterly basis, I have a need to create a Word mail merge document,
listing all the people who belong to one company. (It has to be a merge in
Word to allow a 3rd party broadcast faxing software to interface with the
merge and send it to the desired destinations.)

Currently the database is set up in a one-to-many relationship, with a table
for the company info and another with each of the people in those companies.

In order to do the mail merge to Word, I have to get all of the information
together in one flat file. (Because it's already a one-to-many, there is a
link by company code.) Any suggestions how this can be accomplished to be
able to be run on a quarterly basis?

Thanks.

Rita
 
Rita_M said:
On a quarterly basis, I have a need to create a Word mail merge document,
listing all the people who belong to one company. (It has to be a merge in
Word to allow a 3rd party broadcast faxing software to interface with the
merge and send it to the desired destinations.)

Currently the database is set up in a one-to-many relationship, with a table
for the company info and another with each of the people in those companies.

In order to do the mail merge to Word, I have to get all of the information
together in one flat file. (Because it's already a one-to-many, there is a
link by company code.) Any suggestions how this can be accomplished to be
able to be run on a quarterly basis?
Click to expand...


If you can create a query the produced the desired data,
then you can just export the query or use the query for the
mail merge.
 
Back
Top