+ Reply to Thread
Results 1 to 4 of 4

Outlook VB Code to export attachment

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Outlook VB Code to export attachment

    Hello:


    I have 3 accounts setup in Outlook email with Inbox and subfolders.

    Account 1 : [email protected]
    Account 2 : [email protected]
    Account 3 L [email protected]

    I need outlook VB Code to export all attachment from [email protected], Inbox/Subfolder1 to C:\EmailAttachment\[email protected]\

    Please let me know if you have any questions.
    Thanks.

    Riz

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Outlook VB Code to export attachment

    This utility might do the trick for you: https://www.excelforum.com/tips-and-...subfolder.html
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Outlook VB Code to export attachment

    Hello dflak:

    Please refer to attached pic.
    These are pic from Outlook as i have 3 email accounts.

    Below is the code i use and it works with Outlook\Inbox\@1DQGuntPolling

    Need to change below code so that it works for GMail\Inbox\@1DQGuntPolling.
    I believe its the 1st line i need help with.

    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Thanks.
    Attached Images Attached Images
    Last edited by rizmomin; 07-17-2018 at 04:25 PM.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Outlook VB Code to export attachment

    I'll have to look into my code, but I think if you specify GMAIL as the mailbox and @1DQGuntPolling as the folder it will work. My code assumes INBOX is between Mailbox and Folder.

+ 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. How to prevent VBA Code from saving same outlook attachment again ?
    By avis_1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2016, 12:31 PM
  2. [SOLVED] VBA code to send excel attachment through outlook 2010
    By Liz_Biz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 08:33 AM
  3. code to save attachment from Outlook mail
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2014, 07:11 AM
  4. can anyone provide the source code for Extract the attachment from outlook
    By cherrychan in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2013, 08:03 AM
  5. Export Outlook Attachment (Excel 2003) and directly dump into Access
    By barbibchn in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 01-11-2013, 05:10 PM
  6. Code to attach a sheet as an Outlook email attachment
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2011, 11:32 AM
  7. VBA code to email different attachment to different person using outlook
    By rav4u_tom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2010, 07:23 AM

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