+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Outlook 2010 rule to export data to Excel? in Technical; I have just been setting up the Help Desk feature of our VLE (Frog) so that staff can submit problems ...
  1. #1
    themightymrp's Avatar
    Join Date
    Dec 2009
    Location
    Leeds, West Yorkshire
    Posts
    1,182
    Thank Post
    206
    Thanked 221 Times in 190 Posts
    Rep Power
    72

    Outlook 2010 rule to export data to Excel?

    I have just been setting up the Help Desk feature of our VLE (Frog) so that staff can submit problems which are then sent to my email address.

    Does anybody know of a way of creating an email Rule which would parse the email for subject headings and then split the data off and export it to Excel or Access?

    For example, an email arrives to me looking like this:

    Time:
    25th April 2012 (Wednesday) 15:36:28

    Contact Name:
    Somebody Smith

    E-mail::
    blahdeblah@schoolemail.net

    Equipment_ID::
    Room 30

    Problem::
    The is a problem with such and such a machine
    I would like the email to arrive and Outlook to recognise the headings and export the data into a spreadheet/database. This way I can keep a long term log of faults.

    Any help appreciated

    Cheers

  2. #2

    Steve21's Avatar
    Join Date
    Feb 2011
    Location
    Swindon
    Posts
    2,686
    Thank Post
    333
    Thanked 513 Times in 481 Posts
    Rep Power
    178
    You "could" set it up like this:

    Run vba script to copy to textfile, then run excel macro which would be setup to import the data.

    "Should work" (Disclaimer ), but not exactly "smooth", and would need to be able to actually run the scripts/excel etc on a computer.

    Steve

  3. Thanks to Steve21 from:

    themightymrp (27th April 2012)

  4. #3
    themightymrp's Avatar
    Join Date
    Dec 2009
    Location
    Leeds, West Yorkshire
    Posts
    1,182
    Thank Post
    206
    Thanked 221 Times in 190 Posts
    Rep Power
    72
    I will have a pop at that thanks

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] How to export data that you insert in a VB Form into a spreadsheet
    By EaglesNerd in forum Office Software
    Replies: 13
    Last Post: 26th March 2011, 11:08 AM
  2. Software to replicated data to DR site
    By fox1977 in forum How do you do....it?
    Replies: 5
    Last Post: 26th January 2011, 11:31 AM
  3. Outlook.com to Outlook 2010
    By DaveMurphy in forum Windows
    Replies: 0
    Last Post: 23rd November 2010, 05:34 PM
  4. Replies: 0
    Last Post: 25th October 2010, 08:23 PM
  5. Outlook 2010 not saving Sent Items to PST file.
    By mrforgetful in forum Office Software
    Replies: 4
    Last Post: 25th November 2009, 11:19 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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