A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 1st 09, 01:21 PM posted to microsoft.public.outlook.program_vba
pradeep_siemens[_2_]
external usenet poster
 
Posts: 1
Default 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

Ads
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract data from outlook into excel. VBA_Newbie Outlook - Using Forms 1 September 20th 08 07:04 AM
outlook 2003 macro to extract calendar appointment info to Excel CPOjoe Outlook - Calandaring 3 July 15th 08 05:04 PM
Macro to extract subject and sender name of messages in folder to Excel file bony_tony Outlook and VBA 0 March 7th 07 02:16 AM
Call macro stored in Excel workbook from Outlook's macro Gvaram Outlook and VBA 5 October 4th 06 07:26 AM
Macro to import Excel data to Tasks Patrix317 Outlook and VBA 2 May 2nd 06 07:32 PM


All times are GMT +1. The time now is 09:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.