Importing body text from Outlook email to Excel throws up an error

I've cobbled together the code below from hunting around on this forum but it's not working.

Please Login or Register  to view this content.

The line in red shows the error "Method 'Body' of object '_MailItem' failed".

Any ideas on why it throws this up rather than copying the body text to the worksheet?

I will also need to amend this to look for the folder "TEST" in a shared inbox rather than my own one so any help on that would also be greatly appreciated.

Thanks in advance.

B.

Two things:
1) You need a reference set to the MS Outlook Object library. Use Tools/References in the VBA editor to set this.
2) The code will trigger a dialog box asking if you want to allow Excel to access Outlook. If that dialog box is hidden by another window, it may appear things are not working.

Thanks for the reply.
1) I have a reference set to the Outlook Library. The code wouldn't get as far as it did without that.
2) There is no dialog box, hidden or otherwise. Just the error message detailed above.

I tried the same code on my home computer and it works fine. But when in the office and on the network it doesn't. And that's where I really need it to work.

B.

If you don't get any dialog box asking permission to access the Outlook application, then maybe there's a security issue, you might ask your IT folks.