Mail Merging with More than one Query and Similar Keys?

Using them, Making them, Finding them
Post Reply
leeand00
Posts: 63
Joined: Fri Feb 22, 2008 12:09 am

Mail Merging with More than one Query and Similar Keys?

Post by leeand00 »

Is it possible to do a mail merge with more than one query from a base database?

Say for instance that I already have a table that contains jobs, and companies, and that from queries from these tables I can already generate cover letters with personalized contact information.

Now when the results of these queries return, each of the results contains a job_id from the job table, and a company_id from the company table.

Is it then possible to create another query that would take each of the id pairs (company_id and job_id) from the first query, and return a list of skills that I would need for each individual job to then place in the cover letter?

Thanks!
Post Reply