Use Excel's VBA to identify certain emails in LotusNotes & then to have VB download & open the accompanying attachments

Posted on 2006-05-05
Last Modified: 2013-12-18
I only know a little VB, but I'd like to learn how to write VB code from within Microsoft Excel & have it to loop through all of the emails in my LotusNotes Inbox & then identify all emails that meet either a sender or subject header criterion.  Once those emails have been identified, I would like to have VB download any attached Excel files, and then save the files on my hard drive in my C:/temp folder.  Sound doable?  I'd greatly appreciate any help with this.
Question by:strattergize
    LVL 14

    Accepted Solution

    why from excel VBA? you can use lotus script which is similar to vb syntax.
    LVL 18

    Assisted Solution

    Hi strattergize,
    Agreed, much easier to accomplish in Lotus Script from within Notes.

    Here is a sample database from Sandbox:,attachments,url

    This works really well.  YOu can create a "view" in your Notes database with the criteria you want, or a folder and move stuff matching your criteria to the folder.  The view will display those documents, and then you simply run the agent on the selected emails.


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now