Method two: How to run a VBA sub procedure by clicking a button in Excel Another group on the Developer tab is the Controls group, which includes a button control.

If you have users who prefer to push Excel data into Outlook instead of importing it from inside Outlook, try this VBA event procedure.