#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 108
Default Extract text

Hi, I have the following mail:

Subject: PAC63 filed a flight plan KMIA - SBKP

I want to create a macro that extracts the subject from each email, stroed
on a folder named flights

And Also, everytime it extracts the text, insert it on a schedule divided in
columns monday, tuesday, wednesday, thursday, friday, saturday, sunday
and each row, I would like to add the information of the flight, for
example, if the email is dated monday, then add the text PAC63 KMIA -SBKP
under monday column ,and so on with all the emails in the folder.

Please.

thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract Text Peanut Excel Worksheet Functions 3 May 5th 08 05:43 PM
Need to extract certain text from text string Trista @ Pacific Excel Worksheet Functions 4 November 21st 07 07:07 PM
Extract text from large Text ldiaz Excel Discussion (Misc queries) 4 November 14th 07 01:21 AM
EXTRACT TEXT FROM TEXT STRING carricka Excel Worksheet Functions 4 July 8th 05 11:00 AM
Extract text someone Excel Worksheet Functions 12 January 23rd 05 12:24 AM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"