How To Create a Microsoft Access Macro to Export Information to Excel or Word:
1.Click on the "Macros" option in the "Objects" menu.
2.Click "New" in the upper-panel of the database window to create a new macro.
3.Click in the "Action" field.
4.Click on the drop-down arrow and go to "MsgBox".
5.Go to the "Action Arguments" pane by clicking in the "Message" field or pressing "F6". To toggle to and from the "Action Arguments...