Outlook specific text to Excel VBA Stops after first match

I wrote a code to pull data from outlook to excel, And its 80% working It does pull info but not from the whole email.

I receive emails in the same format with pricing and other info on them. These are for purchase orders what have more than 1 line usually. They are in this format:

Item Number : 00001

Vendor Sales Order Number :

Vendor Material Number :

SAP Material Number :

Vendor Description :

SAP Description :

Vendor Quantity : 30.000 EA

SAP Quantity : 30.000 EA

Quantity UOM : EA

Vendor Delivery Date : 20.09.2014

SAP Delivery Date : 20.09.2014

Action Request :

Following details does not match for PO line item 00001

Vendor Price : USD 0.00 for 1 EA

SAP Price : USD 0.01 for 1 EA

Item Number : 00002

Vendor Sales Order Number :

Vendor Material Number :

SAP Material Number :

Vendor Description :

SAP Description :

Vendor Quantity : 70.000 EA

SAP Quantity : 70.000 EA

Quantity UOM : EA

Vendor Price : USD 3.90 for 1 EA

SAP Price : USD 3.90 for 1 EA

Vendor Delivery Date : 20.09.2014

SAP Delivery Date : 20.09.2014

Action Request :

Quantity and Requested Date all matched with PO. Item 00002

As you can see from the code i am pulling multiple things from these emails that have the same beginning string. Most of the time these templates come in via email with more than one line item. After it pulls line 1, the code moves to the next email without searching the entire body of the email for further matches that are present in some. How can i fix this?

( I put the extra text fields in place if i need them to add more criteria later )

Please Login or Register  to view this content.

Hello cgcustomcomputers,

Did you check that the Ubound of vText is greater than -1? The Split method creates a 1_D array with the first element starting at zero.