What it does
Allows you to export a list of emails from Outlook, filtering based on the folders the emails are in and date ranges.  Using the Email Picker macro, you can quickly open any email in the list.

When to use it
When you want to export a list of emails and common email fields, this is a very quick way to do it.  Often this is used to easily make a list of emails to follow-up on, draft a to-do list, or just see a list of emails for a particular project.

Why to use it
It’s a very quick way to create a list of emails based on the folder(s) they are housed in and a date range.

Default shortcut
None

Other Details

• Category: MS Office / Outlook
• Difficulty: 2/5
• Usage/frequency: 2/5
• Automation factor: 5/5 (estimated 300 seconds saved each time used)
• Type: Bulk
• Date added: 9/10/2018
• Tags: Outlook, export, email, folder, list

Related Macros
Email Picker
File Email Messages

Other Articles
None

Export Outlook Emails – Example File

Instructions
Run the Export Outlook Emails macro.  At the prompt, enter the email account you want to export emails from.  The Email_Folders sheet is created in the active workbook, which lists all the email folders that currently exist in Outlook.  These are the columns within the Email_Folders sheet you’ll want to fill in:

• Column C – Export? (required): enter “Yes” for any folders from which you want to export a list of emails.
• Column D – Filter Start (optional): enter the starting email receipt date and time to filter the list of exported emails.  While not required, this is highly recommended to prevent the macro from running longer than desired.
• Column E – Filter End (optional): enter the ending email receipt date and time to filter the list of exported emails.  While not required, this is highly recommended to prevent the macro from running longer than desired.

After determining the folders to export emails from and the optional date ranges, run the Export Outlook Emails macro again.  Another sheet is created in the active workbook called Export_Outlook_Emails containing a list of emails meeting the folder and date range criteria, containing key email fields.   To open an email to read, review, etc., use the Email Picker macro (default shortcut of Ctrl+o), option O to open the email with the Email ID (column J) for the row you have selected.