Solved: Access 2007: Creating a Button to allow user to export report to Excel

I have several reports from a database that I have built for my boss to see different views of work progress. She currently copies and pastes to put them in Excel.

I'd like to provide her with a button she can click to Export everything to Excel for her. She is not the most tech-savvy, so showing her how to do it within Access is not a feasible option (she'd just ask me to show her every time she needed to do it).

Thanks in advance!

 

In Form design Mode the Form "Button Wizard" will create the button for you.
The fourth item on the "button sub menu" is Report Operations and on the right hand side the last option is Send Report to File.
You then select the report that you want and then "Output to MS Exel"

 

Thank you! For some reason I was missing that option!