Thread: Extract text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
juanpablo juanpablo is offline
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