Populating subject line of email

[ckitzman]

I've set up command button to email a snapshot result of a query. Is there a way to populate the subject line of the email relative to the query.

ex. I query for lname, fname, and cust# and other data for a report. The mail button throws a snapshot attachment into an email, I'd like the customer name and number to be in the subject line of the email.

thoughts?

thanks in advance
--ck