+ Reply to Thread
Results 1 to 7 of 7

Power query additional source of data or VBA needed?

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

    Power query additional source of data or VBA needed?

    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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,688

    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
    Registered User
    Join Date
    02-23-2022
    Location
    Warszawa
    MS-Off Ver
    16
    Posts
    15

    Power query additional source of data or VBA needed?

    Hi,

    Thanks to power query I can import emails from outlook to excel. But unfortunately I can do that only for one Inbox. Do you know how to do that for few folders.

    I am working for international company and I'm managing of some inboxes. I want to import all data together to one excel file
    Last edited by AliGW; 02-26-2022 at 11:44 AM.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,688

    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.

  6. #6
    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,351

    Re: Power query additional source of data or VBA needed?

    I have merged two threads here, as this is all about the same issue, but with two possible approaches.
    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.

  7. #7
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,377

    Re: Power query additional source of data or VBA needed?

    Something like this

    Please Login or Register  to view this content.

+ 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] Power Query Data Source Error
    By plasteredric in forum Excel General
    Replies: 3
    Last Post: 12-30-2022, 02:10 AM
  2. [SOLVED] Power query showing different values then the source data
    By randall78 in forum Excel General
    Replies: 4
    Last Post: 03-18-2021, 10:12 AM
  3. vba to change power query data source folder
    By Undo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-22-2021, 11:29 PM
  4. [SOLVED] Tabulating Source Data using Power Query
    By josephteh in forum Excel General
    Replies: 2
    Last Post: 12-29-2020, 07:54 AM
  5. Replies: 0
    Last Post: 08-25-2020, 03:56 PM
  6. [SOLVED] Power Query Only selecetd(parametrs) data to be download from source
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2020, 03:09 PM
  7. Dropbox Data Host/Source for Power Query
    By mielkew27 in forum Excel General
    Replies: 0
    Last Post: 04-09-2017, 11:49 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