Hi,
I'm new to VBA Outlook so hope someone could help.
I get emails like this everyday:
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Westget ID : 10205
Receipt ID : 57080367
Bills Grabbed
2011_2011_34_2_2_001473_1_5_1_20111108_0
2011_2011_34_2_2_001473_1_5_3_20111108_0
2011_2011_34_2_2_001477_1_4_4_20111107_0
2011_2011_34_2_7_003053_1_4_1_20111108_0
2011_2011_34_2_7_003053_1_4_3_20111108_0
2011_2011_34_2_7_003054_1_4_1_20111108_0
2011_2011_34_2_7_003054_1_4_3_20111108_0
2011_2011_34_3_2_002370_1_5_1_20111108_0
2011_2011_34_3_2_002370_1_5_3_20111108_0
2011_2011_34_3_2_002370_1_4_4_20111107_0
2011_2011_34_3_2_002370_1_5_4_20111108_0
2011_2011_34_3_2_002371_1_4_4_20111107_0
History Grabbed
2011_2011_34_2_2_001473_1_9_2
2011_2011_34_2_2_001475_1_9_2
2011_2011_34_2_2_001476_1_9_2
2011_2011_34_2_7_003053_1_9_2
2011_2011_34_2_7_003054_1_9_2
2011_2011_34_3_2_002370_1_9_2
2011_2011_34_3_2_002371_1_9_2
WorkFlow Start Time = 20111109 01:26:31
WorkFlow End Time = 20111109 01:44:13
Acquisition Start Time = 20111109 01:24:21
Acquisition End Time = 20111109 01:26:23
Number of Bills Acquired Successfully = 12
Number of Bill Tracks Acquired Successfully = 7
-------------------------------------------------------------------------------------------------------------------------------------------------------
And I would need the IDs after "Bills Grabbed" and before "History Grabbed" which are
2011_2011_34_2_2_001473_1_5_1_20111108_0
2011_2011_34_2_2_001473_1_5_3_20111108_0
2011_2011_34_2_2_001477_1_4_4_20111107_0
2011_2011_34_2_7_003053_1_4_1_20111108_0
2011_2011_34_2_7_003053_1_4_3_20111108_0
2011_2011_34_2_7_003054_1_4_1_20111108_0
2011_2011_34_2_7_003054_1_4_3_20111108_0
2011_2011_34_3_2_002370_1_5_1_20111108_0
2011_2011_34_3_2_002370_1_5_3_20111108_0
2011_2011_34_3_2_002370_1_4_4_20111107_0
2011_2011_34_3_2_002370_1_5_4_20111108_0
2011_2011_34_3_2_002371_1_4_4_20111107_0
to be exported to a certain column in an Excel file that I have with just clicking a button in Outlook. This excel file that I have have formulas and macros in it to help me sort the data so I would really need this excel file to be the file that I have stored in my drive somewhere.
Thanks in advance!
I'm new to VBA Outlook so hope someone could help.
I get emails like this everyday:
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Westget ID : 10205
Receipt ID : 57080367
Bills Grabbed
2011_2011_34_2_2_001473_1_5_1_20111108_0
2011_2011_34_2_2_001473_1_5_3_20111108_0
2011_2011_34_2_2_001477_1_4_4_20111107_0
2011_2011_34_2_7_003053_1_4_1_20111108_0
2011_2011_34_2_7_003053_1_4_3_20111108_0
2011_2011_34_2_7_003054_1_4_1_20111108_0
2011_2011_34_2_7_003054_1_4_3_20111108_0
2011_2011_34_3_2_002370_1_5_1_20111108_0
2011_2011_34_3_2_002370_1_5_3_20111108_0
2011_2011_34_3_2_002370_1_4_4_20111107_0
2011_2011_34_3_2_002370_1_5_4_20111108_0
2011_2011_34_3_2_002371_1_4_4_20111107_0
History Grabbed
2011_2011_34_2_2_001473_1_9_2
2011_2011_34_2_2_001475_1_9_2
2011_2011_34_2_2_001476_1_9_2
2011_2011_34_2_7_003053_1_9_2
2011_2011_34_2_7_003054_1_9_2
2011_2011_34_3_2_002370_1_9_2
2011_2011_34_3_2_002371_1_9_2
WorkFlow Start Time = 20111109 01:26:31
WorkFlow End Time = 20111109 01:44:13
Acquisition Start Time = 20111109 01:24:21
Acquisition End Time = 20111109 01:26:23
Number of Bills Acquired Successfully = 12
Number of Bill Tracks Acquired Successfully = 7
-------------------------------------------------------------------------------------------------------------------------------------------------------
And I would need the IDs after "Bills Grabbed" and before "History Grabbed" which are
2011_2011_34_2_2_001473_1_5_1_20111108_0
2011_2011_34_2_2_001473_1_5_3_20111108_0
2011_2011_34_2_2_001477_1_4_4_20111107_0
2011_2011_34_2_7_003053_1_4_1_20111108_0
2011_2011_34_2_7_003053_1_4_3_20111108_0
2011_2011_34_2_7_003054_1_4_1_20111108_0
2011_2011_34_2_7_003054_1_4_3_20111108_0
2011_2011_34_3_2_002370_1_5_1_20111108_0
2011_2011_34_3_2_002370_1_5_3_20111108_0
2011_2011_34_3_2_002370_1_4_4_20111107_0
2011_2011_34_3_2_002370_1_5_4_20111108_0
2011_2011_34_3_2_002371_1_4_4_20111107_0
to be exported to a certain column in an Excel file that I have with just clicking a button in Outlook. This excel file that I have have formulas and macros in it to help me sort the data so I would really need this excel file to be the file that I have stored in my drive somewhere.
Thanks in advance!