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
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