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.
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.