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.
Message Utilities
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
Leave a Reply
4 Comments on "Message Extraction Tools"
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/
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.