+ 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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,131

    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
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,131

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,053

    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" 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.

  7. #7
    Valued Forum Contributor
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    550

    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 showing different values then the source data
    By randall78 in forum Excel General
    Replies: 4
    Last Post: 03-18-2021, 10:12 AM
  2. [SOLVED] Power Query Data Source Error
    By plasteredric in forum Excel General
    Replies: 2
    Last Post: 03-01-2021, 12:17 PM
  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