Take a query, export it to excel with a password and email it...with one button click lol

[IH8XEL]

Ok Access Gurus,
I have a form. In this form I have a button that runs a parameter query with an "On Click" embedded macro. I figured out a way to send it to email with an excel output file as the second action. But I need the excel file to be password protected. The password can be the same exact password every time. I can't figure out a way to do all 3 things (run the query, password, and email) with one click of the button. Please help!!!

 

[Micron]

I'd be surprised if you could do this from Access without using automation, which is well above the power of a macro AFAIK. Take a look here or search for something like

ms access password protect excel file automation