OneNote Email Page from Section | VBA Macro #63

This is a OneNote macro designed to give you the ability to quickly email the contents of a OneNote Page directly from Outlook. When this macro is run a popup will display all of the OneNote Page options from the OneNote Section (.one file) indicated in the VBA code. To select a OneNote Page simply enter in the leading number that displays in from of its title. Once a leading number is entered an Outlook email will display including all of the contents from the OneNote Page selected. If the OneNote Page contains attachments these will automatically be attached to the Outlook emails that displays. This handling of attachments from within the OneNote Page mirrors the Email Page button you can click from OneNote directly. If you would rather have the attachments embedded into the Outlook email body you can update the VBA code below so the format is Rich Text.

See it in Action!

Watch this video to see this macro in action.

***Video coming soon!***

The Code

Here is the code for this macro. Make sure the following References are setup before running it: Visual Basic For Applications, Microsoft Outlook 16.0 Object Library, Microsoft Office 16.0 Object Library, Microsoft Word 16.0 Object Library

Insider Content

Here is the Insider code for this macro. This code will allow you to setup a Word Document to reference that contains the additional content you want pulled into the beginning of your Outlook email! This can contain a simply greeting, a reference to the OneNote Page below, even your Outlook Email Signature (including images). Make sure the following References are setup before running it: Visual Basic For Applications, Microsoft Outlook 16.0 Object Library, Microsoft Office 16.0 Object Library, Microsoft Word 16.0 Object Library

First time using VBA?

The Developer Tab is an additional section of the ribbon when activated allows you access to Visual Basic in Applications like Access, Excel, Outlook, PowerPoint, Word.
Setup Now
Once the Developer Tab is available you will have the capability to update your security to allow Macros to run in the current application.
Setup Now
A sub of code is a collection of objects and variables. For the code to successfully run a library of references needs to be set.
Setup Now
Subscribe as an Insider to receive additional rights.
If you like our content and want to show your support tip us here!

Contact Us

Looking to improve your computer processes?
Leverage & Lean is here to help!

Powered By MemberPress WooCommerce Plus Integration

Free Macro

Start creating Less Clicks, More Results today!