How to export specific emails to excel?

Microsoft Office 2007 professional (aca...
April 7, 2010 at 06:01:41
Specs: Windows 7, 4gb
I am stuck at a problem where I want to export emails with specific "TO" ( can be a Distribution List). And I expect the excel to have the email address of the sender and the time at which the email was received. Is there a way to do this? I have looked on several forums and sites, but unable to find something like this.

My ultimate goal is to track the emails coming in my Microsoft outlook sent to me Distribution List and export them in an excel sheet. The objective is to look for the number of emails recieved and the time/date at which it was received.

Note: I am using an IMAP account on my outlook and there is no exchange server.

Any help is great appreciated!


See More: How to export specific emails to excel?

Report •


#1
April 7, 2010 at 09:33:38
Create a folder for the emails. Then, create a rule that moves emails sent to that list to the folder. That's how you can track them. No need to do extra work of exporting them when the information is right there in Outlook.

id10t


Report •

#2
April 7, 2010 at 22:20:29
Thanks for your reply. But this is not something that I am looking for. I am looking for the email sender and the time of the email received to be exported in an excel format. I am aware about creating rules and making sure that all the emails from the sender/DL to be placed in a specific folder.

Thanks, Need help!!


Report •

#3
April 8, 2010 at 16:27:27
If you really want the redundancy, all you have to do is export the emails to a spreadsheet and in the Map Custom Fields option, delete all but the sender and the date/time.

It's a very simple process.

id10t


Report •

Related Solutions

#4
April 9, 2010 at 01:57:41
Thanks! But I dont understand how can I export emails? Can I also automate this process?

Report •

#5
April 9, 2010 at 06:21:11
File, Import and Export, Export to a file,.......follow the wizard.

Another option would be to turn on the Journal.

Again, you already have the information in Outlook. Why cause yourself more work..

id10t


Report •


Ask Question