How to export with custom fields in Outlook?
Letβs say you have added several custom fields in a mail folder in Outlook, however, these custom fields are ignored when you export emails from the folder. Any solutions? This article will introduce a workaround to export emails/contacts/tasks with custom fields in Outlook.
Export contacts with custom fields in Outlook
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
- BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
- Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
- Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
- More than 100 advanced features will solve most of your problems in Outlook 2021 - 2010 or Office 365. Full features 60-day free trial.
Export contacts with custom fields in Outlook
This workaround will guide you to show the custom fields in the Outlook folder whose items you will export, and then copy all items in this folder to an Excel workbook.
This workaround will take exporting emails from a mail folder for example.
1. In Outlook, open the folder whose items you will export, and click View > Add Columns. See screenshot:
2. In the opening Show Columns dialog box, please do as follows:
(1) Select the User-defined fields in Inbox option from the Select available columns from drop down list;
(2) Click to highlight the specified custom field you will export with in the Available columns list box;
(3) Click the Add button;
(4) Keep the new added column selected in the Show these columns in this order list box, and click the Move Up or Move Down buttons to change its order.
(5) Repeat above (1)-(4) to add other custom fields as you need, and click the OK button.
3. Now custom fields are added in the mail folder. Please click View > Reading Pane > Off to turn off the reading pane.
4. Please select all emails in the mail folder, and then press Ctrl + C keys together to copy them.
Note: You can select all emails with clicking the first one, and then pressing the Ctrl + Shift + End keys simultaneously.
5. Launcher Microsoft Excel, select the first cell in a new worksheet, and press Ctrl + V keys together to paste the emails, and then save the workbook.
So far, all emails in the specified mail folder have been exported with the specific custom fields to Excel workbook.
Related Articles
Remove To field in Message window in Outlook
Export search results in Outlook to PST/Excel file
Export emails by date range to Excel file or PST file in Outlook
Best Office Productivity Tools
Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook
β Email Automation: Auto Reply (Out of Office) / Schedule Send emails / Auto CC/BCC / Advanced Auto Forward / Auto Add Greating ...
β Email Management: Easily Recall Emails / Block Scam Emails / Delete Duplicate Emails / πAdvanced Search / Consolidate Folders ...
π Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
π Interface & Interaction Magic: πMore Pretty and Cool Emojis / Brings Browser Tabs Right Into Your Outlook / Minimize Outlook Instead of Closing ...
π One-click Wonders: Reply All with Incoming Attachments / Anti-Phishing Emails / πShow Sender's Time Zone / Send to Recipients Separately ...
π©πΌβπ€βπ©π» Contacts & Calendar: Batch Add Contacts From Selected Emails / Split a Contact Group to Individual Groups / Remove Birthday Reminders ...
Over 100 Features Await Your Exploration! Click Here to Discover More.