Trying to export attachment from Outlook to Excel

  • I want to create code in excel that will look for a specific sender or subject from Outlook and copy the workbook attachment to a specific location on my desktop. I have no clue 1) if this is possible or 2) how to do it. I would also like to have it be a scheduled event that happens every Monday thru Friday.


    I have this code currently but it only seems to work in outlook. Can I change this code to work in excel?


  • Re: Trying to export attachment from Outlook to Excel

    Try adding a reference to Microsoft Outlook x.x Object Library using the Tools/References menus in the Excel VBA dev environment - if it works in Outlook, it should then work in Excel with no, or very minor, changes...

  • Re: Trying to export attachment from Outlook to Excel

    I selected this tool and I get a compile error: User-defined type not defined. What do I need to declare to get this to work correctly...I am new to VBA and I am trying to learn as I go.


  • Re: Trying to export attachment from Outlook to Excel

    Nevermind....I selected Office object library instead of Outlook.

    And it works great!


  • Some tools are available in the market, you can search through google or i will recommend Softaken Outlook PST Extractor tool, this software will help you to export attachment from Outlook to Excel file format. This software have more features to extract outlook PST to, CC, BCC Email Addresses, Attachments, Calendars and Contacts etc. Go ahead and download free software link here -

  • There are multiple solution available for Extract Outlook PST data into Other file format. That easily Outlook PST Extractor to Extract Attachments, Emails Address, Calendars and Contacts from PST. You can Google this solution. Last time i used a solution for same issue and got great result with this tool. I will recommend you to download DataVare Outlook Attachment Extractor software.

    Visit here:-…attachment-extractor.html

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!