Automating with Macros

[Guest]

I have a series of actions that occur every day that I would like to try and
have done with clicking a button to execute the Macro.

The problem is this:
When the query kicks off, I want it to ask for a beginning and ending date
then the output of the query needs to be transformed to an Excel spreadsheet
and emailed for processing. Is there a way I can get the macro to do all
this or am I overreaching the capabilities of Access?

Thanks for your ideas and input.

 

[Guest]

Never Mind! I had a breakthough and all works beautifully!