+ Reply to Thread
Results 1 to 3 of 3

Extract attachments from Notes 'sub' folder

  1. #1
    Registered User
    Join Date
    12-08-2011
    Location
    Newfoundland, Canada
    MS-Off Ver
    Excel 2013
    Posts
    10

    Extract attachments from Notes 'sub' folder

    I am trying to use Ron DeBruin's VBA code to extract attachments from one of my Lotus Notes folders. It works great for messages in my Inbox, but I need to use a different folder called ICS where I save emails from a specific supplier with individual PDF attachments.

    One line of the code is...

    Please Login or Register  to view this content.
    I have tried replacing $Inbox with ICS and Folders\ICS and \Folders\ICS and everything else I can think of.

    Any suggestions?

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Extract attachments from Notes 'sub' folder

    If the ICS folder is within Notes' own Folders folder, as you are indicating, then the following should work:
    Please Login or Register  to view this content.
    If not, try the following call and associated subroutine to dump the Views and Folders to the VBA Immediate window:
    Please Login or Register  to view this content.
    With this you should be able to identify the exact name of the folder.
    Post responsibly. Search for excelforum.com

  3. #3
    Registered User
    Join Date
    12-08-2011
    Location
    Newfoundland, Canada
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Extract attachments from Notes 'sub' folder

    Thanks Chippy.

    My problem was that I was replacing the original code GetView("($Inbox)") with GetView("(ICS)").

    Once I removed the parenthesis within the quotes and used GetView("ICS"), it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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