ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extract text (https://www.excelbanter.com/excel-discussion-misc-queries/188988-extract-text.html)

juanpablo

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



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com