Query result as Email subject

[firestorm998]

Curently run a Send.Object function on a form to retrieve a unique record via a query. I'd like to be able to send a particular field returned by the query to use as the subject title in the email that is auto-created.
The query will only ever be returning a single record but that single record will change each time it is run.


Any ideas people?


Thanks in advance.

 

[KeithG]

Search the VBA/Module forum for sending an email. You can use the Outlook object modle to send the email. Also you can use dlookup t o retrieve the value of the field of yuor query.