+ Reply to Thread
Results 1 to 2 of 2

Outlook to Excel - list of inbox

  1. #1
    Registered User
    Join Date
    06-16-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Outlook to Excel - list of inbox

    i am trying to figure out how to have an excel file updated every time an email arrives, I would like to have

    Sender
    Sent time
    Subject
    Body

    in four separate columns. I know this may not be the appropriate forum but I can not seem to figure out how to do this and you guys seem to have the answers to everything. I am using 2010. Any suggestions would be helpful. Thanks!

    I found this code on mrexcel, but I haevnt gotten it to work yet, run time error 1004, it opens the excel sheet- the first time it dumped information in one cell but I have not been able to get it to process anything since then.

    Please Login or Register  to view this content.
    Last edited by siray13; 09-08-2012 at 05:01 PM.

  2. #2
    Forum Contributor
    Join Date
    08-01-2012
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Outlook to Excel - list of inbox

    Perhaps try:

    http://www.techrepublic.com/blog/mso...s-to-excel/744
    http://www.itjungle.com/fhg/fhg100610-story01.html
    http://msdn.microsoft.com/en-us/libr.../ee814736.aspx
    http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx


    You are going to end up combining elements of other scripts assuming they exist. Check out the outlook object model so you can understand how to utilize it. If you don't get a reply here, another great place to check out is stackoverflow, or the social MSDN site. Do some research on the different methods and try to fully understand what the script is doing so you can take control. Perhaps search for other things such as "export outlook emails on arrival" and you might be able to find some useful items to help you.
    Last edited by jayinthe813; 09-09-2012 at 12:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1