Using query like source to mass emails

Suppose a query with Field A and A1, A2, … are its values; Field B and B1,
B2, …
In a record, A1 could be associated with B1 and with B3 in another record;
A2 could be associated with B2, B5 and B8 in others records…
Suppose A Field like Customers Field. I want to email A1 and mention (in
this email) all B values associated with A1 value. And so makes the same for
all A values.
How can I do that?

Hi

One method is to create a list from your table
include
Email address
Name
Report name
etc
etc

then check out this answer to the same question I gave a while ago - we send
out reports to clients each week (about 2,500 reports) each report has a
different title that is specific to the client.

http://groups.google.com/group/micro....public.access

if you have problems post back with questions

--
Wayne
Manchester, England.



"Alogon" wrote:

Suppose a query with Field A and A1, A2, … are its values; Field B and B1,
B2, …
In a record, A1 could be associated with B1 and with B3 in another record;
A2 could be associated with B2, B5 and B8 in others records…
Suppose A Field like Customers Field. I want to email A1 and mention (in
this email) all B values associated with A1 value. And so makes the same for
all A values.
How can I do that?