Access and mail merge filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top