ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro (https://www.excelbanter.com/excel-discussion-misc-queries/188225-macro.html)

juanpablo

Macro
 
Hi,

I receive an email every day with the following format:

Subject: PAC63 filed a flight plan SBKP - SCEL

Body: Your tracked aircraft PAC63 has just filed a flight plan. It is
scheduled to depart SBKP (Viracopos) at 08:25PM GMT heading for SCEL (Arturo
Merino Benitez Int'l) for an arrival at 11:55PM GMT.

I want to create and Excel macro that extracts this info, and create some
kind of schedule with the information in each email, for example: (So every
time i run the macro, it extracts all the information from one outlook folder
and populate the schedule on an excel sheet, with the information of date
extracted from the email date. Example

Monday 15 april Tuesday 16 april ...
Sunday
SBKP-SCEL
ETD:8.25PMGMT
ETA:11.55PMGMT

Any possibilities?


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

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