Exctract text in Outlook Message


Joined
Nov 14, 2011
Messages
1
Reaction score
0
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!:cheers:


 
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


Top