none
How to export Outlook message body to Excel RRS feed

  • Question

  • Hi,

    I'm new to VBA but not completely unaware of how it works. We receive regular emails for printer statistics and I'd like them to be exported into a spreadsheet. Could anybody help me on how to do this? Each time I try and include a sample of the email, it removes the paragraph spacing. Because of this, the sample email will have hyphens (-) to identify when there is a paragraph space.

    -----Original Message-----

    From: donotreply@domain.co.uk [mailto:donotreply@domain.co.uk]

    Sent: 01 August 2013 11:23

    To: Printer Readings

    Subject: (Office Name Here) - Status Message

    (-)

    2013/08/01 10:23:24

    (-)

    Device Name: (Office Name Here)

    Device Model: (Printer Model Here)

    (-)

    Serial Number: (Printer Serial Here)

    Machine Code: (Machine Code Here - Sometimes Left Blank)

    (-)

    Current Device Counter Information:

    (-)

    Black & White Copy Count = 70335

    Two Colour Copy Count = 0

    Single Colour Copy Count = 0

    Full Colour Copy Count = 14109

    (-)

    Black & White Print Count = 120920

    Full Colour Print Count = 71010

    (-)

    Black & White Total Print Count = 191317 Two Colour Total Print Count = 0 Single Colour Total Print Count = 0 Colour Total Print Count = 85179

    (-)

    Black & White Scanner Count = 10829

    Two Colour Scanner Count = 0

    Single Colour Scanner Count = 0

    Full Colour Scanner Count = 876

    Wednesday, August 21, 2013 8:54 AM

All replies