Outlook Parsing a line in Outlook 2007 using VBA


Joined
Mar 4, 2012
Messages
3
Reaction score
0
Hi,
Currently I have a scenario where we are requested by our corporate client to quote them of cost of Air Ticket to there required Destination.
Upon getting the email, we use our GDS System to book the flight. There upon the booked flight along with the fare is copied to a new outlook message box and sent to them. Before sending, I have to delete a lot of data from it. Is there any possible way to keep specific lines in Outlook body and delete the rest of data. For Exammple, when I copy from our GDS to Outlook the data is some what like this:

NO NAMES
1 EK 7B 29JUN 5 DXBLHR SS1 0230 0700 /DCEK /E
ADD ADVANCE PASSENGER INFORMATION SSR DOCS
AS PER EU REGULATIONS PAX CAN ADV EMERGENCY CTC IN SSR PCTC
2F2B.2F2B*AGU 0038/04MAR12
WPNCB«
BASE FARE TAXES TOTAL
1- AED2800.00 80.00XT AED2880.00ADT
XT 75.00AE 5.00TP
2800.00 80.00 2880.00TTL
ADT-01 B1SOWAE1
DXB EK LON Q30.00 729.64NUC759.64END ROE3.673
NON-END/SKYWARDS SAVER/
VALIDATING CARRIER - EK

AIR EXTRAS AVAILABLE - SEE WP*AE

I want to keep only the red lines and remove the rest of the data.

Regards,
 
Ad

Advertisements


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

Similar Threads

Excel Concatenate Form Name to Parse for function 1

Top