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

  • Thread starter pradeep_siemens
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro help 0

Top