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