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 ...
26th April 2012, 03:55 PM #1
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:
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.
25th April 2012 (Wednesday) 15:36:28
The is a problem with such and such a machine
Any help appreciated
26th April 2012, 04:56 PM #2
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.
Thanks to Steve21 from:
themightymrp (27th April 2012)
27th April 2012, 11:02 AM #3
I will have a pop at that thanks
By EaglesNerd in forum Office Software
Last Post: 26th March 2011, 11:08 AM
By fox1977 in forum How do you do....it?
Last Post: 26th January 2011, 11:31 AM
By DaveMurphy in forum Windows
Last Post: 23rd November 2010, 05:34 PM
By DaveP in forum Downloads
Last Post: 25th October 2010, 08:23 PM
By mrforgetful in forum Office Software
Last Post: 25th November 2009, 11:19 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)