access queries leading

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - queries leading to mailmerges

Access - queries leading to mailmerges

resolvedResolved · 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


 

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.09 secs.