Access 2000 - creating mailing list

First thing, I'm a little surprised at your question. After all, your profile reads: Enterprise Applications: MS SQL Server.

So on to the question: Sure it's possible. We create mailing lists like this often. The SQL would look like:

SELECT person.f_name, person.l_name, person.e_mail, amount
FROM person, person_paid
WHERE person_id = person_paid
AND person_paid.amount_due < person_paid.amount_owing

This wuld be a Create Table type of query and you can add any fields from person thatyou like or need.

The concatenation function is used to combine the output from two (or more) fields or one statement and one field (or more) into one string. it can be very useful. So if in the finished table I wanted the persons first and last name to be one field I would simply say:

SELECT person.first_name + person.last_name as NAME
from PERSON

Exporting the result set into a bulk email program or into a mail-merge function is a very powerful combination!

Regards
Raffi_

If you are already familiar with queries use the Access "Query View" to construct your mailing address recordset. It doesn't matter if your data is linked to Access or SQL Server.

Do any 'concatenating' in the query so it's easy to quickly checkresults before saving your work.

In the Access "Field:" area enter the column name you want followed by a colon. i.e., Person:

Add a space and begin concatenating:
[TableName1].[LastName] & ", " & [TableName1].[FirstName]

Add whatever criteria determines who is added to your list in your query.

This will produce a list (recordset) of e-mail recipients by name in a column titled "Person".