Outlook extract with VBA - no value (<>) for e.g. e-mail body - a security issue?

Hi all,

For documentation purposes I'm trying to get an extract from the folder contents of my Outlook mailbox on my corporate laptop&account. I've found an amazing code to do so, however when I run it, it only extracts the Subject, ReceivedTime and Folder name. It does not extract the Body, SenderName, SenderEmailAddress and To fields. For these fields when debugging and running it step by step it displays no value (i.e. '<>') for these fields and I fear this has something to do with our corporate security settings - given that when I run this code on my private laptop & outlook box, it works perfectly.


Is there any way to surpass these, such as by running all applications as an administrator?

Thanks all!

Please find the code used below - credits to Bill Prew from experts-change for making it.

Please Login or Register  to view this content.

You may have your reasons as why you want to run a macro to extract the email data, processing it further from there...
An alternative is to use the Outlook Import/Export option. You get all fields, including body of emails.
File > Open & Export > Import/Export > Export to a file > Comma Separated Values (CSV) ...select folders, follow prompts.

Glad it works for you. Thanks for the feedback.