#Outlook color code emails archive
#Outlook color code emails code

ThisWorkbook.Sheets(1).Cells(1, 2) = 'Subject' ThisWorkbook.Sheets(1).Cells(1, 1) = 'Sender' 'Read Through each Mail and export the details to Excel for Email Archival If VBA.UCase(sFolders.Name) = VBA.UCase(Pst_Folder_Name) Then If VBA.UCase(Folder.Name) = VBA.UCase(Pst_Folder_Name) Then GoTo Label_Folder_Found 'To access a main folder or a subfolder (level-1)ДЇor Each Folder In (MailBoxName).Folders 'Set Folder = (MailBoxName).Folders(Pst_Folder_Name) Pst_Folder_Name = 'Folder Name' 'Sample 'Inbox' or 'Sent Items' 'Mailbox Folder or PST Folder Name (As how it is displayed in your Outlook Session) 'Mailbox or PST Main Folder Name (As how it is displayed in your Outlook Session) 'nn.n varies as per our Outlook InstallationДim MailBoxName As String, Pst_Folder_Name As String 'Add Tools->References->'Microsoft Outlook nn.n Object Library'

#Outlook color code emails code

Note: If you are executing this code in Outlook VBA, then above reference is not required.Д®xport Outlook emails to Excel with date and time Outlook application should be running in your machine.Change вЂњ Mail box NameвЂќ & вЂњ Folder NameвЂќ from where you need to extract the email data.(nn.n is version of Object Library that varies depending on your Office Installation) Go to Tools -> References & enable вЂњMicrosoft Outlook nn.n Object Library.Here is the VBA code to extract emails from Outlook to Excel.Дownload & Try this Excel before using the Code Downloaded 8,404 TimesД«efore executing the code, make a note of these points. Outlook VBA: Copy Email Fields to Excel with Date and Time More Advanced Options are hereвЂ¦ Download Outlook Mail Attachments to local Folder 2. It will have email fields like sender, email body, date and time etc.,

ДЄll the email items from the chosen PST folder will be downloaded to Excel.

Map Outlook field headers with output Excel column headers.

Type Output Excel File path to export Email data.

Choose вЂOutlook Folder to ExportвЂ™ & click next.

Select вЂњMicrosoft Excel 97-2003вЂќ & Enter.

Choose вЂњExport to a fileвЂќ & press Enter.

Click File menu or Office Ribbon in Outlook.

Lets start to learn all possible methods, one by one.

Outlook VBA: Export emails from Outlook to Excel VBA with date and time.

#Outlook color code emails archive

To Export Outlook email data to Excel & archive mails, we have 3 options here. Export Emails From Outlook to Excel with Date and Time