Outlook VBA OneNote Page Template

Derek 1 Reputation point

I've set up a rule in outlook to automatically forward emails containing a specific subject to create a page into a specific section in OneNote.

Is there a way to combine this with a template in OneNote.

For example, I receive a message, message is forwarded to OneNote, Onenote creates a new page with the template (say an excel sheet), including the email.

Here is the current Outlook VBA I am running as an rule:

Sub ChangeSubjectForward(Item As Outlook.MailItem)
Item.Subject = "@ Deal Tracker"

Set myForward = Item.Forward
myForward.Recipients.Add "me@onenote .com"


End Sub

{count} votes