Bypass email attachment dialog box

[2vbr]

I send spreadsheets as attachments via Outlook, so I placed a SEND TO MAIL RECIPIENT shortcut on the Quick Access toolbar.

Problem is, evey time I press it the button, this dialog box pops up:

KNBdFq7.png

Is there any way to bypass it? The answer will always be "as an attachment", and will NEVER be in the message body. It's just a frustrating, unecessary step I'm hoping to somehow skip to speed things up.

[6StringJazzer]

It involves VBA. This code will create a new email in Outlook with the active workbook as an attachment.

Please Login or Register  to view this content.

If you are not familiar with macros let me know and I will give you instructions for how to install it. The idea is to install it to your PERSONAL.xlsb file then create a button on the quick access toolbar to run it.