Results 1 to 2 of 2
2006-10-18, 14:32 #1
- Join Date
- Jul 2006
- Thanked 0 Times in 0 Posts
Automatically extracting data from email (2003)
Is is possible to automatically extract data from an outlook 2003 email and place it into an Excel spreadsheet
| (Embedded image Data Network Request System |
| moved to file: Request For Service |
| pic06543.jpg) Originated by Fred Smith on 17/10/2006 |
| RFS Number: 0062/181006 |
| Status: Supplier Solutioning
In the above example email l would like the RFS number, Originated by name and originated date to be automatically imported into cells in an Excel spreadsheet, it would save me a lot of time and effort if this could be done.
2006-10-18, 19:43 #2
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 94 Times in 90 Posts
Re: Automatically extracting data from email (2003
Well, there is automatic when you open the message and click a button, and there is "unattended" automatic. For the latter, you can use the Rules feature, specifying an action in "Script." Actually it isn't script, you write a VBA (Visual Basic for Applications) procedure for either approach.
It probably would be a few hours work to write the procedure and test it if you are familiar with VBA; much longer if you aren't. I won't elaborate on the details except to note that there are some past Outlook-to-Elsewhere solutions discussed on this board, on VB/VBA, and on the application boards (e.g., Access, Word).