macroland Macroland

Macroland currently has 638 macros by 352 authors
Sort By:

Macros by: JasonDaSilva

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 SubPagerEMail

by JasonDaSilva

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....

Last Updated: January 17, 2017

Outlook FROM SubPager

This Macro is designed to work with Sections consiting only of pages that we sent from Outlook. attempting to use this macro with other types of pages can have unforseen results.
Do you wish to continue?
See macros from other authors