P
pradeep_siemens
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 (e-mail address removed) for any info.
many thanks
pradeep
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 (e-mail address removed) for any info.
many thanks
pradeep