Simple report export to excel

[crombiecrunch]

Hello all



I am trying to setup a command button that will export a report to excel. The data collection is in a tabe called FaxCollection which only has 3 things sold to, ship to, and fax number. I am looking to set up something simple that I can just hit a button and dump those three colums in to the excel file.

[JoeM]

Create a Macro, using the "OutputTo" Action to output your report to an Excel file. The arguments needed for that Action are explained in detail in the Macro builder.
Then, assign that Macro to your Command Button.

[crombiecrunch]

oh nice and easy thank you