98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access - queries leading to mailmerges
Access - queries leading to mailmerges
Resolved · High Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change The Default Font in Access 2003You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set. |