macroland Macroland

Macroland currently has 615 macros by 332 authors
Sort By:

Category: EMail

Outlook Email Date StampEMail

by Omer Atay, JasonDaSilva

This macro will change the creation date of each page in the current section with the time the email was sent, allowing them to be sorted by the email date. This has been made specifically for emails sent to OneNote from Outlook.

Last Updated: February 11, 2018

Outlook Email Date Stamp

This Macro will change the page creation date to match the Sent date on the email. This will then allow you to use the Sort by Date macro regardless of when you moved the mail message to OneNote. Email sent date is in a row in the table. The first column says 'Sent' in English, change that based on your language below. The second column has the date, provide the format for the date. This looks something like: ┌──────┬──────────────────────────────────┐ │ Sent │ Friday, February 9, 2018 7:05 PM │ └──────┴──────────────────────────────────┘ Legend for Date Format (examples use values from the date above) Y: 4 digit year (2018) M: 2 digit month (02) D: 2 digit day (09) y: 2 digit year (18) m: 1 or 2 digit month (2) d: 1 or 2 digit day (9) H: 2 digit hour (07) T: 2 digit minute (05) W: Day of the week (Friday) h: 1 or 2 digit hour (7) t: 1 or 2 digit minute (5) N: Month name (February) A: AM or PM (PM) ?: Any 1 character (Useful for things like ?? for -th, -st, -nd, -rd suffixes) For month and day names list short names below if that is the case (Jan,Feb,Mar,...) Also use any other character directly as it appears like comma (,) or space ( ) To get 'Friday, February 9, 2018 7:05 PM', you would need 'W, N d, Y h:T A' as the date format
First column value ('Sent' in English)
Date Format (Use legend above)
Scope
------------------------------------------------------------------------------------------------
Separate values below with comma
Month names (Use short names if they appear as such on the page)
Day names starting Sunday (Use short names if they appear as such on the page)
AM and PM values if applicable

Outlook FROM SubPager

EMail

Creates header pages for each sender, then sorts and sets emails as subpages under the header pages. Running it a second time removes the subpaging, sorts by name, but cannot remove the header pages. These are renamed 0000DeleteMe for easy removal. This tool is for use with emails that were sent to OneNote specifically from Outlook. It may not work with exports/prints from other mail clients. Updated Jan 2017

Add icon to all emails

EMail

This macro will change the title of each page in the current section to add an email emoji to the beginning (unless it already has one). This has been made specifically for emails sent to OneNote from Outlook. Great from seeing all emails in a section at a glance.

Date Modifier for Imported Email from Outlook

EMail

This macro is essentially a modified version of the "Outlook Email Date Stamp" by Omer Atay and JasonDaSilva. The modification is that the user prompt is in french and the macro works for e-mails in french and german. It should also work for italian but it wasn't tested. As of early 2020, imported e-mails seem to have some information in english (namely the fields such as "sent", "from", and so on) even though the system and program were installed in a different language. Therefore the macro got adapted to handle e-mails with english fields, even though it should have been in another of the available languages. Description of the original macro: "This macro will change the creation date of each page in the current section with the time the email was sent, allowing them to be sorted by the email date. This has been made specifically for emails sent to OneNote from Outlook."

Page and Title modifier for imported Outlook Emails

EMail

This macro works for e-mails imported in OneNote from Outlook only. The user prompt is in french. What it does is set the OneNote page date to the one of the e-mail within it. Added to that, it also changes the title of the page by adding the date of the e-mail at the beginning of it and add a few glyphs showing that it's an e-mail, if there are any attachments and finally if the e-mail was sent or received. The macro handles dates in german, french and italian.

See macros in other categories