Read e-Mail attachment, grab data, copy into excel file.

Hello,

I receive daily several mails with either excel or pdf attachments. The attachments have the following format.
[TABLE="border: 1, cellpadding: 1"]

[tr]

[td]

Code:

[/td]

[td]

1000

[/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

Date

[/td]

[td]

Company

[/td]

[td]

Currency

[/td]

[td]

amount

[/td]

[td]

remark

[/td]

[/tr]

[tr]

[td]

11.11.2017

[/td]

[td]

AA

[/td]

[td]

DOLLAR

[/td]

[td]

20000

[/td]

[td]

hello

[/td]

[/tr]

[tr]

[td]

11.11.2017

[/td]

[td]

BB

[/td]

[td]

DOLLAR

[/td]

[td]

20000

[/td]

[td]

hello

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

12.11.2017

[/td]

[td]

AA

[/td]

[td]

DOLLAR

[/td]

[td]

20000

[/td]

[td]

hello

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

I want to extract the information for today's date into a preexisting excel sheet which looks like that: (The field "name" is already pre-filled according to the "code")
[TABLE="border: 1, cellpadding: 1, width: 500"]

[tr]

[td]

Date

[/td]

[td]

Company

[/td]

[td]

Currency

[/td]

[td]

Amount

[/td]

[td]

Name

[/td]

[td]

Code

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Abel

[/td]

[td]

1000

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Abel

[/td]

[td]

1000

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Beta

[/td]

[td]

1005

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Eta

[/td]

[td]

2099

[/td]

[td][/td]

[/tr]

[/TABLE]

Now, what I would love to have is a VBA code that reads the e-mail attachment and copies the relevant data into the preexisting excel sheet so that in the end it will look like this:

[TABLE="border: 1, cellpadding: 1, width: 500"]

[tr]

[td]

Date

[/td]

[td]

Company

[/td]

[td]

Currency

[/td]

[td]

Amount

[/td]

[td]

Name

[/td]

[td]

Code

[/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[td]

11.11.2017

[/td]

[td]

AA

[/td]

[td]

DOLLAR

[/td]

[td]

20000

[/td]

[td]

Abel

[/td]

[td]

1000

[/td]

[/tr]

[tr]

[td]

11.11.2017

[/td]

[td]

BB

[/td]

[td]

DOLLAR

[/td]

[td]

20000

[/td]

[td]

Abel

[/td]

[td]

1000

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Beta

[/td]

[td]

1005

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

Eta

[/td]

[td]

2099

[/td]

[/tr]

[/TABLE]

Is something like this even possible?