Emailing just records instead of the whole query

[Guest]

Is it possible to email a record to an email address without sending the
whole query?

I have a query that that lists a unique number, persons name, persons email
address - along with some other data.

I want to send out emails to all persons listed - but only the records with
their names - not the other records.

Will I need to create a separate query for each person?

Any Suggestions?

Thanks.

 

[Guest]

Does anyone have the answer to this question? This is exactly what I need...

 

[Geoff]

Is it possible to email a record to an email address
You do not need to create a separate query for each person. Write a VBA
program that will open the query as a recordset. Loop through the recordset
one record at a time. Use the information in each record to construct an
outgoing email using Microsoft Outlook. Controlling Outlook from Access
means writing some "Automation" code. Sending one email to each peron is
probably the simplest way. The alternative is to loop through the
recordset, constructing a string of email addresses and putting the whole
string in the "bcc" (blind carbon copy) field of an outgoing email addressed
to yourself. Recipients will not then see each other's email addresses.

Geoff