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

Posted on 2006-05-05
Medium Priority
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

cezarF earned 500 total points
ID: 16647568
why from excel VBA? you can use lotus script which is similar to vb syntax.
LVL 18

Assisted Solution

marilyng earned 500 total points
ID: 16676213
Hi strattergize,
Agreed, much easier to accomplish in Lotus Script from within Notes.

Here is a sample database from Sandbox:

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
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.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

750 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