Help creatng a macro to run a query before sending an email message.

[Jacqueline]

I am creating a macro where...

'On Click' of a command button on a form...

1. a query using a parameter is opened...and then a
function (SendEmail) runs to send an email to that
queries result set.

In the query...If I hard code in a date as criteria the
email sends...but if I put in an [Enter date] parameter I
get an error message.

I was wondering if this would work...
if I ran the parameter query and saved it's result set as
a new query name...and then ran the 'SendEmail' code with
this new queries results.

1. What actions do I use to save the parameter query
result as a new query name??

2. After sending the email to those addresses from the
query I need a checkbox value in the
table 'Acknowledgement' to update to reflect that person
was sent the acknowledgement email.

thanks for any help...