Placeholder

Customer Forum

Create a button to BCC your Dropbox and send email

Workbooks Support Posted: 2015-10-21 13:58

Do you find yourself not using the Dropbox enough? Sometimes it can be a hassle to enter in the Dropbox address to the BCC field, and sometimes we simply forget to do so!

This forum post will show you how to create a button that will BCC in your Dropbox address, and send the message all with the click of a single button.

Firstly, we will need to open Outlook, and press ALT + F11, which will bring up Visual Basic Editor.

In VBA, click on Insert, and then Module:

And then paste the following text into the new module:

--------------------------------------------------------------------------------------

Sub Dropbox ()

Dim myOlApp As Outlook.Application

Dim myItem As Outlook.MailItem

Dim objOutlookRecip As Outlook.Recipient

Set myOlApp = GetObject(, "Outlook.Application")

Set myItem = myOlApp.ActiveInspector.CurrentItem

With myItem

   .BCC = "[ENTER YOUR DROPBOX EMAIL HERE]"

End With

myItem.Send

End Sub

-----------------------------------------------------------------------

Enter in your Dropbox address so that it looks like the screenshot below:

Then simply hit the save button in Visual Basic, and close the VB window.

Now we need to set up this macro, so that it can be accessed from the New Email ribbon.

Right click on the ribbon at the top of the page, and select 'Customize the Ribbon'.

From within this menu, you will need to make a New Group, which we'll call  Dropbox This; after this select Macros from the dropdown box called Choose commands from.

Add the relevant VB script that we just created into the group, and then click OK at the bottom to save it.

You should now see a button like this in your New Email view, clicking this instead of the Send button will automatically send the email to the specified recipient as well as sending a copy to your Dropbox address so that it can be processed in Workbooks as well.