Rich Thomas
asked on
Is it possible to "harvest" email addresses from the email messages in an Outlook 2007 inbox with 1000's of emails?
Prior to deleting thousands of emails from an Outlook 2007 inbox I would like to capture/save the following info from each email: person's name, email address, and other info like company name, street address.
Similarly, is there a way to save all of the attachments without saving each one individually?
Thanks.
Similarly, is there a way to save all of the attachments without saving each one individually?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Since I am not a programmer pcelba's comment is beyond my pay grade. I understand Phillip's solution but I was hoping to find something simpler and more direct.
Paygrade? Well... depends on the country where you are making the money :-).
Even relatively low US paygrade could mean high paygrade for India, Ukraine etc.
So you may outsource the task (e.g. here: https://www.freelancer.com/work/programming-contract-bid)
or take some programming lessons which could elevate you to the higher grade.
Even relatively low US paygrade could mean high paygrade for India, Ukraine etc.
So you may outsource the task (e.g. here: https://www.freelancer.com/work/programming-contract-bid)
or take some programming lessons which could elevate you to the higher grade.
my solution is fairly direct, and simple to do.
One program to extract attachments and MSGs, and to harvest the details.
One program to extract attachments and MSGs, and to harvest the details.
ASKER
I looked at their website. They have a download before you try option so I could take a closer look at this. Sometimes the limitations are such that it's hard to tell whether the software will do what you want. I would assume that this software would be a "1 computer per license" so I may have to buy a couple of copies as I have a couple of computers with these crazy big pst files. Do you know?
If they are in PST files, then you can open them on a single computer, just like you can more than one Word document on a single computer.
Hi, RMThomas8.
If a scripted solution is acceptable, then see this page on my blog.
https://techniclee.wordpress.com/2011/08/25/harvesting-all-email-addresses-from-an-outlook-mailbox/
If a scripted solution is acceptable, then see this page on my blog.
https://techniclee.wordpress.com/2011/08/25/harvesting-all-email-addresses-from-an-outlook-mailbox/
CREATEOBJECT(“Outlook.appl
and use the object created for whatever you need incl. addresses harvesting. Everything you need is a simple loop which will go through all inbox messages and stores addresses to some database table for the future use. Easy task for beginners.
Code samples exist:
FoxPro - http://www.aksel.com/whitepapers/OutlookAutomation.htm
C# - http://support.microsoft.com/en-us/kb/819398
VB - https://msdn.microsoft.com/en-us/library/office/ff865816.aspx
Python - http://win32com.goermezer.de/content/category/7/86/192/
MS Access - https://www.experts-exchange.com/Database/MS_Access/VP_179.html
etc.
Outlook object model also supports attachments so you may save them during the addresses harvesting. The work with Outlook via automation is similar no matter what programming language you use. The code from one language is easily portable into another language.