I receive emails with tab delimited data looking like this

9:46 ET AAA 100 BBBB CCC DDD [EEEEEEEE]

I'd like to grab this data directly from my email account and load into
Excel sheet.

ColumnA = 9:46 ET
ColumnB = AAA
ColumnC = 100
ColumnD = BBBB
ColumnE = CCC
ColumnF = DDD
ColumnG = EEEEEEEE

I think I understand how to connect to outlook but I don't know the
rest
What is the method to parse based on delimiter? Or how else can I do
this

Thoughts

Thanks
Steve