Email items from a query in subject line

Hi,

I have a query that has the following fields:

LOG_#
Record Count
LNP_Prov
LNP_Recd_Date
EmailAddress
FName

This is the data set

114048
116
Smith.Happy
4/28/2005
Happy.Smith@globalcrossing.com
Happy

It only brings up one record. I would like it send an email from
access 2000 via outlook with this in the subject.

Log 114048

I want the email message to state:

Happy,

116 records for log 114048 have been entered into your queue on
04-28-2005.

Thanks

re: Email items from a query in subject line

automate Outlook.

You can create the text of the message in a variable and then assign it
to the .Body property of the message.

The other way is to build your message body in a query and then use
Sendobject.