Solved

Automatically Export Outlook Email Messages to Excel

Posted on 2007-03-23
3
279 Views
Last Modified: 2010-09-02
How can I automatically export Outlook email messages to an excel spreadsheet as they are received?  I think the best way might be to use a rule to run a script but I don't know how to write that script.  Does anyone have any suggestions or script samples?  I am doing this so that I can have our users email their IT problems/requests and then our techs could check the spreadsheet to see what needs to be done, sort of an automatic to-do list.  i want it to be in excel so that the techs can add notes and so that the users could check the status of their requests.  I am open to any other suggestions though.
0
Comment
Question by:rtchristie
3 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 250 total points
ID: 18780423
I'd recommend using a database instead of a spreadsheet.  If someone has the spreadsheet open in edit mode when an item arrives, then I don't think that item can be written into the spreadsheet.  I expect at that point the spreadhseet will be locked.  That aside, yes this is possible.  There is a hitch though.  Accessing any Outlook field that contains or may contain an email address is going to trigger Outlook security.  That will cause a dialog-box to pop up warning that an application is accessing your mailbox and asking you for permission to allow it to continue.  There's no way to turn this off, but there are ways to work around it.  The two simplest approaches require the use of third-party software, one free (I beleive) the other not free.  
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question