Problem with Excel accessing an Outlook email body

Hi everyone,

I've been scouring the internet for hours trying to find information on how to copy the body of a series of e-mails into excel.

I have to run the code from excel. Here's what I currently have.

Please Login or Register  to view this content.

The error is with olMail.Body

"Run-time error '287':
Application-defined or object-defined error"

Does anyone know how to fix this problem? I'm stumped.

Thanks

I can't test given I have no access to shared folders but my first question would be: when prompted in OL (security) are you granting XL access ?

others may have other ideas...