Macro

J

juanpablo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top