Closed Thread
Results 1 to 7 of 7

VBA Macro saving emails to excel file

  1. #1
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    VBA Macro saving emails to excel file

    Hello,

    Do you know plugin or add-in or macro...I do not know... which save all emails from selected folder to prepared excel file?

    I need information from every email like:

    From | Subject | Received | Categories | Flag Categories

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,866

    Re: VBA Macro saving emails to excel file

    Are you talking about emails saved to a Windows folder as files, or a folder under an account in Outlook? Or something else?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    Re: VBA Macro saving emails to excel file

    I would like to import emails from selected folders in Outlook to excel file. For example

    Excel file should look like:

    From Subject Received
    Antony B Please change code... 25.02.2022 14:34
    Marc.P. Please maintain artcicle... 23.02.2022. 11:05

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,866

    Re: VBA Macro saving emails to excel file

    Please attach an Excel file showing exactly what you want your result to look like. See yellow banner at the top of the page.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,630

    Re: VBA Macro saving emails to excel file

    Do you want to do this with VBA or PowerQuery? You need to make your mind up, as you currently have two threads asking more or less the same question.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  6. #6
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    Re: VBA Macro saving emails to excel file

    Hi,

    I want to use Power Query for that. I chosen: Data->Get Data->From other sources->From Microsoft Exchanges, but I can type only one Mailbox adress. I need to import data from 3 email boxes. How to solve it

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,630

    Re: VBA Macro saving emails to excel file

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here where I have merged the two threads: https://www.excelforum.com/excel-gen...ba-needed.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Macro saving emails to excel file
    By excelowy_amator in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2022, 10:11 AM
  2. Creating a macro to generate batch emails from a list of addresses in excel file
    By maccabarra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2015, 02:59 PM
  3. How to Add the attachments to the Emails from attached excel macro file
    By Chandrahaas in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2015, 05:33 AM
  4. Macro for selecting & saving a MP4 file from Excel file
    By xlman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2010, 03:31 AM
  5. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM
  6. saving file name and location with excel macro
    By Alex Suardi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  7. macro for processing one excel file and saving it to other
    By shwetaparekh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2005, 07:05 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