Do you need to process information arriving via e-mail by responding to particular text in the message rather than the message as a whole? These utilities help by extracting data from messages, exporting it to a file or database or responding with a custom reply using information from the incoming message.
If you prefer a home-grown solution, you can use regex to locate data within the message. See Use RegEx to extract text from an Outlook email message for more information and sample code. Use a macro to copy data in Outlook email to Excel workbook has sample code to insert data from an Outlook email message into an Excel spreadsheet.
Tools
Merge selected folders from PST files, such as, Inboxes, Calendars, Contacts, Journals, Tasks etc. to another PST file. Combine data from files created in different Outlook versions. All your data stored in original PST files will be preserved and merged without making any changes to the original files. Merge, move or copy specified Outlook data from one PST file to a selected PST file without the need to merge all content from both PST files. PST Merger is compatible with the latest Windows 10 and Outlook 2016. | |
Capture name, address and other contact's details automatically and insert into Microsoft Outlook contact in two simple steps from e-mail signatures, Outlook items, a web page or a document and automatically create a Contact. Highlight the contact information (signatures) found in open e-mails, preview panes, websites, and programs. Capture name and address into Microsoft Outlook address book automatically. | |
Data Publisher add-in provides a means to bring your Outlook contents such as mails, appointments, tasks or contacts to SharePoint lists, where these can be shared with other users. This process can be performed manually, or automatically and is achieved without using any scripts or programming, with complete seamless experience to the users. In other words, Data Publisher extends your Microsoft Outlook to effectively act as a content provider for your enterprise SharePoint repository. It can be adapted to feed data to SharePoint lists for various purposes, such as for issue tracking, timesheets, projects or contact managements. | |
Database Exporter for Outlook enables you to export the contents of an Outlook folder to an external database. It is designed to overcome the inability of the Outlook's built-in 'Import and Export Wizard' to handle data in custom forms, including custom fields. Specify which fields to include in the export. Supports export of mail, appointments, tasks or contacts. Works on any Outlook form, field types and support any Outlook folder and Exchange Public Folders. | |
Convert data from web page form submissions and other message data into Outlook contacts. Processes data in the background. | |
Email Parser is used to retrieve emails from Outlook PST files, Exchange servers or Office 365 accounts and extract the data contained in them. It supports exporting to an Excel file or Google Sheets. C# Scripting and PowerShell is also possible to integrate Email Parser with your existing tools. It has a wide range of examples available at the website and is free to try. | |
Automatically downloads emails from web forms and third party sites, processes them into Outlook and assigns follow-up whenever a lead fills up a Web Form on your web site. Send an Auto-Response Email to the incoming email and also Distribute the Lead email among your Lead Processing Team. Can also create contacts from structured text files, in addition to mail messages.(Formerly Web Response Grabber) | |
Extracts information from incoming messages into databases, sends automatic replies, manages newsletter subscriptions, sends and collates questionnaires. Supports XML and scheduled tasks. | |
Exclaimer Image Analyzer provides business owners with email image scanning functionality, ensuring no images of pornographic or inappropriate nature pass through the corporate email system. Exclaimer Image Analyzer works in conjunction with Active Directory through Exchange server 2007 and 2010. This means any email sent via Outlook, Outlook Express, Smartphones, PDAs and BlackBerrys are automatically scanned for inappropriate content. An initial audit period allows you to report on the level of imagery going through your corporate email system, categorizing them into 'clean' and 'suspect' using the reporting tools. | |
Save&Share's Outlook plugin gives users the ability to copy selected messages directly from their inbox to cloud storage. Messages are stored in three components: 1) original .eml format; 2) message.pdf conversion; and 3) any attachments in original format. Cloud Storage services supported: Box, Google Drive, DropBox. | |
Uses templates to automatically extract information from messages to create mailing lists, gather sales information or compile statistics. | |
MsgViewer Pro is the advanced multi-format email reader for managing your .msg and .eml message files. If you have prevously installed Microsoft Outlook, then MsgViewer can also read and search your .PST files. Export email messages to image formats (PDF, JPG, GIF, TIF, PNG, BMP, TXT or CSV ). | |
Easy-to-use email parser to automatically extract data from your emails. Send the data to Google Sheets, Microsoft Excel, or other applications. | |
Use Stellar Merge PST software to merge or join multiple Outlook PST files into a single file. Merge or join all data items such as Emails, Contacts, Notes, Calendars, Tasks, and Journals without altering the data of the original PST files. Eliminates duplicate data while merging. Removes deleted and junk folders. Supports password-protected Outlook PST files. Free Trial. | |
Priasoft Super-ExMerge is a re-imagined version of a beloved tool from Microsoft Exchange’s earlier days, called ExMerge. This was a tool that could export or import mail data between mailboxes and PST files that is no longer supported / available from Microsoft. Our Super-ExMerge product takes over where ExMerge left off and greatly enhances it’s functionality for today’s modern usage scenarios. |
More Information
- Automatic Message Processing Tools
- Extract data from a structured text block -- basic VBA function to extract data from text block where each line lists a different field name and its data, as in a web form response
Hi Diane, I have received help from you in the past and it is greatly appreciated. I am looking for a solution where I can extract data from email and use vba to get that data into an excel file that is on sharepoint. Weekly we receive aging reports from contractors regarding the status of invoice payments. A request has been made for me to create a way to automatically update an excel file stored on sharepoint with data extracyted from users across the country who also receive aging reports. Basically, the data needed would be the email sender and the date/time email was received. I have a macro that will allow me to extract that data from a selected folder, which I would have the people across the country create in Outlook. However, while the macro does put the data in an excel file, I cannot figure out how to get it in the sharepoint excel for management to review. Below is a sample of the file. It has the contractor name, contractor ermail, contractor id, and the date of the aging report and whetehr it was received. What happens is that each week, ususally on a Friday or… Read more »
Sorry I missed this earlier - you need to use regex to get the values. I have sample macros at https://www.slipstick.com/developer/regex-parse-message-text/ and at https://www.slipstick.com/developer/vba-copy-outlook-email-excel-workbook/
Hi Diane...i'm looking for something very specific. I'm a recruiter and get tons of emails with resumes attached (mostly word docs). I have a custom form i use in my contacts where i paste the text of the resume in the notes section so it becomes searchable. is there anything i can do so that when i open a resume in a word doc...that i can click a button or something to have it automatically extract the name, address, phone and email address and put them in the proper spots on a new contact form...and i can paste the bod of the resume myself. it's a pain to have to click new contact, copy each piece of info manually and drop them into the right places. there must be some way to open a new contact from word and have it done automatically. thanks in advance
The egrabber family of tools might have something... otherwise, you can automate it a bit from word, but picking up all the data will be harder with just a basic macro. Doing this much will be fairly easy: open form, copy document body to notes field. If the name, address, email address are not defined the same way in every resume, you won't be able to pick them up automatically. See Select a name in a Word document then create a Contact for a basic Word macro.
Alternately, you can use a macro to create a contact for the sender of the selected message - this would save one step.