Access and mail merge filtering

[Chiz]

I have a mail merge document set up from an access 2003 database.

I enter all applicants; those that are 'successful' and those that have been
'rejected'.

How do I automatically omit the rejects so they do not get a letter? (At
the moment I manually filter out any rejects).

Can anyone out there help? Please do not reply using too technical terms!

Kath

 

[John Nurick]

Hi Kath,

In Access, create a query which only returns the successful applicants.
I guess you have a yes/no field for "successful", or perhaps a text
field that says "Successful" or "Rejected", or some other means of
telling them apart: put a criterion on this field in the query.

Then go back to your mailmerge document and change its data source so it
goes to the query rather than the table.