+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

    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.
    Last edited by DanielZig; 06-29-2020 at 09:02 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    372

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

    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.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Utrecht
    MS-Off Ver
    2010
    Posts
    14

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

    Cheers, that solves my problem and is a lot easier

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    372

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

    Glad it works for you. Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-12-2017, 04:27 AM
  2. How to extract outlook mail full body context and not just the text?
    By vbahelppls in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2015, 02:29 AM
  3. Replies: 0
    Last Post: 08-17-2015, 11:00 PM
  4. VBA code for copying body of the mail from outlook
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2015, 03:37 AM
  5. Format Outlook Mail Body using VBA
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2014, 07:02 AM
  6. Excel VBA outlook - Range in mail body
    By dphadke@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 06:33 AM
  7. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1