outlook vba run time error

[missy22]

Dear all,
I am trying to retrieve emails (html body) from outlook 2012 into excel 2012. I am using the following code below and currently I am getting an ‘run time error’ 424 ‘object required’ on the following code:

Please Login or Register  to view this content.

This is the rest of my code which I am trying to compile in outlook module:

Please Login or Register  to view this content.

Any help and guidance would be very much appreciated.
Thank you for your time and help.