+ Reply to Thread
Results 1 to 3 of 3

Outlook macro to extract data from e-mail to CSV

  1. #1
    Registered User
    Join Date
    09-22-2021
    Location
    Estonia
    MS-Off Ver
    MS Outlook
    Posts
    2

    Outlook macro to extract data from e-mail to CSV

    Hello,

    Can someone please help me with the following:
    - Macro which would export the contents of a e-mail.
    - The macro should only export the data from one sub-folder in Outlook.
    - Data should be retrieved only from unread e-mails.
    - When data retrieved, then mark e-mail as read.

    Or maybe someone could point me to something which already exists?
    I'm going to be pretty honest, I'm really bad at VBA and don't understand coding.


    Kind regards,
    M
    Last edited by Mehis; 09-22-2021 at 10:02 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Outlook macro to extract data from e-mail to CSV

    Hi Mehis and welcome to the forum.

    You might start by watching a few YouTube like this one to see if it solves your question.
    https://www.youtube.com/watch?v=apBglZR9W60
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-22-2021
    Location
    Estonia
    MS-Off Ver
    MS Outlook
    Posts
    2

    Re: Outlook macro to extract data from e-mail to CSV

    Hi Marvin!

    Thank you very much for the link but unfortunately in order to automate my workflow I'd like it to be automatic, so there wouldn't be a need to refresh the excel each time when I expect some additional data.

+ 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. [SOLVED] Outlook extract with VBA - no value (<>) for e.g. e-mail body - a security issue?
    By DanielZig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2020, 10:39 AM
  2. VBA/Macro : sending daily e-mail from Outlook data to an excel worksheet
    By Shoshana in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2019, 09:12 AM
  3. 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
  4. VBA code to extract data from MS outlook mail.
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2013, 02:19 PM
  5. How to extract data from Outlook Mail to Excel (VBA)
    By rafeemd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2011, 01:16 AM
  6. Macro - extract outlook mail
    By Djimmy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2010, 09:45 PM
  7. outlook redemtion macro cant send mail if outlook is not open ?
    By okl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2010, 07:35 AM

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