query results in message of email

[deekras]

how do i put the query results in the message of the email (not as an attachment)?

would it be different if it was a report, and not a query?

the query has only 2 fields and probably up to records.

thanks

 

[Hayley Baxter]

How are you looking to run the query? Are you going to be using a form with an email button to generate it or would you like to run this without any user input?

Have a look at the attached example. There are two email buttons. The first email button emails the current record only. The second email button loops through the recordset sending an email to everyone in turn.

 

[deekras]

i wamnt to send 1 email to the same email address. the contents of the email will be different every time. i want to send a list of all updated members. the query works fine, i want to include the query results in the email, not as an attachment.

 

[Graham T]

deekras

This may give you further help:

Sending E-Mails From Microsoft Access

HTH

Graham