Susan has attended:
Access Introduction course
Access - queries leading to mailmerges
I have recently run a query which tells me the name and ref no of units that have applied for a grant in the period leading up to 31/12/2006. However I need to write to the contact person at each unit to ask them for feedback, and i need to run a query which gives me the address for the units that I have already obtained on my first query, so I can then run a mailmerge. is there a simple way of doing this?
Thanks.
RE: Access - queries leading to mailmerges
Hi Susan
If I have this correct, you have a query that shows the Ref No and the Name of only the Units that applied for grants in the given period (e.g. Grants_2006).
To create a query to obtain their addresses do the following:
1. Create a new query (e.g. Grant_Addresses_2006)
2. In the query combine the Grants_2006 query with the table (e.g. Unit_Details) that holds the Unit's address details and pull down the following fields:
From the Grants_2006 query
