Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Access - queries leading to mailmerges
|
|
|
Bookmark this page|
The UK's most regular 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 - queries leading to mailmerges
Resolved · High Priority · Version 2003
Reply
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.
For upcoming training course dates see: Pricing & availability
RE: Access - queries leading to mailmerges
Hi SusanIf 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
|
 |
|
» Forum post: Training |
Will we receive the training exercises that we did in the class
