+ Reply to Thread
Results 1 to 4 of 4

loop through a excel range to download email attachments from outlook folder

  1. #1
    Registered User
    Join Date
    02-05-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    11

    loop through a excel range to download email attachments from outlook folder

    I have a list of of files which i need to download from different folders of outlook in a excel sheet in the below order.

    Starting Row 2 to 10 but can be more in future
    Column A: File / attachment name
    Column B: Email Subject Line
    Column C: Outlook Folder Name
    Column D: Save as location for attachements (different for each)

    Now I have below function which I got through google search which I want to use, below is what i have so far, also I want to add the subject line and filename as string (since I want to name the attachment as its mentioned in the worksheet while saving) which is missing in the function:

    Please Login or Register  to view this content.


    Cross Posted on Mrexcel earlier: https://www.mrexcel.com/forum/excel-...ok-folder.html

  2. #2
    Registered User
    Join Date
    02-05-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    11

    Re: loop through a excel range to download email attachments from outlook folder

    Can someone help with the above code

  3. #3
    Registered User
    Join Date
    02-05-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    11

    Re: loop through a excel range to download email attachments from outlook folder

    Can someone help with the above code

  4. #4
    Registered User
    Join Date
    02-05-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    11

    Re: loop through a excel range to download email attachments from outlook folder

    Can someone help with the above code

+ 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. Alternative way to download attachments from outlook from Excel
    By chunkyp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2017, 06:45 AM
  2. VBA to Select 2nd Outlook Account and Download attachments
    By Bogdan Scorpion in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2015, 12:03 PM
  3. Macro to Print all attachments across multiple emails in Outlook folder then delete email
    By Melissa Camp in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2015, 05:45 PM
  4. Replies: 1
    Last Post: 10-18-2014, 05:04 PM
  5. move Excel attachments in email to a folder
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2014, 09:56 AM
  6. [SOLVED] Excel Macro to download email attachments from MS Outlook.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2010, 02:10 PM
  7. [SOLVED] Excel Macro to download attachments from multiple sub folders of outlook
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2010, 09:32 AM

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