Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |