Closed Thread
Results 1 to 7 of 7

VBA Macro saving emails to excel file

  1. 02-26-2022, 06:36 AM #1
    excelowy_amator
    excelowy_amator is offline
    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
    Reply With QuoteRegister To Reply
  2. 02-26-2022, 08:52 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    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]
    Reply With QuoteRegister To Reply
  3. 02-26-2022, 10:01 AM #3
    excelowy_amator
    excelowy_amator is offline
    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
    Reply With QuoteRegister To Reply
  4. 02-26-2022, 10:16 AM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    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.
    Reply With QuoteRegister To Reply
  5. 02-26-2022, 10:16 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,403

    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" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 02-26-2022, 11:21 AM #6
    excelowy_amator
    excelowy_amator is offline
    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
    Reply With QuoteRegister To Reply
  7. 02-26-2022, 11:45 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,403

    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
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next 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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1