none
Extracting data from outlook 2016 emails to excel 2016 RRS feed

  • Question

  • Hi,

    I have been asked to produce a report in excel showing the following fields - Total number of objects backed up, Total number of objects expired, Total number of bytes transferred - that are available in my email.  There is 1 email per day, each similar. 100 emails all together.

    --------------------------------------------------------
    mmbackup: Backup of /camp begins at Tue Jun 19 18:01:11 BST 2018.
    --------------------------------------------------------
    mmbackup: TSM Summary Information:
    Total number of objects inspected: 2778245
    Total number of objects backed up: 2149750
    Total number of objects updated: 0
    Total number of objects rebound: 0
    Total number of objects deleted: 0
    Total number of objects expired: 530024
    Total number of objects failed: 4263
    Total number of objects encrypted: 0
    Total number of bytes inspected: 29977120298233
    Total number of bytes transferred: 30529303225146
    Wed Jun 20 05:43:38 2018 mmbackup:Completed successfully. TSM exit status:  exit 0
    ----------------------------------------------------------
    mmbackup: Backup of /camp completed successfully at Wed Jun 20 05:43:39 BST 2018.
    ----------------------------------------------------------

    I am looking to write a VBA code that extracts and presents this data in excel.

    Can you advise?

    Thanks

    Sunday, July 22, 2018 6:22 PM