expecting your helping hand - need a macro to extract data from mails to excel
 

HI experts
Seeking your help badly i get official mails in a form which i have
enclosed. i normally receive 200 similar mails per day. if some one can
help me with a macro which can be fed into outlook so that on running
the macro that can be updated in a excel sheet like the excel sheet i
have enclosed for your reference.
form we recive through outlook as a mail




MPRN
3013485400
Date
20/03/2009
Time Raised
17.11
END of SLA
20.11
Full Bgas Contact details
*Lucky @bgas on 183762*
Job Description
Call out, Fault Flag, off supply
Customer Name
Miss. Juli A Harison
Customer Tel No
01473437654
Full Address
4
MELROSE GARDENS
IPSWICH
Postcode
IP4 3NZ
Consumer Off Supply?
yes
CC Agent Contact details
Kanthi * 7010
Comments Further details
CARD NOT ACCEPTING ON MTR , OFF SUPPLY, TRIED WITH 3
CARDS
:: ::


::expected outcome in excel::
*Date**issued by**Mprn**Job Description**Mail Received Time**Time
Raised**Time Issued**issued to**Additional
Comments*24/3/2009pradeep9956487925call out9:088:455:55richard

expecting your helping hand any moment
Plz mail to for any info.
many thanks
pradeep


--
pradeep_siemens
------------------------------------------------------------------------
pradeep_siemens's Profile: http://www.thecodecage.com/forumz/member.php?userid=255
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92134