How to access Lotus Notes address book from Excel worksheet (VBA)

Posted on 2006-05-08
Last Modified: 2013-12-18

I am developing an Excel worksheet to maintain information of a group of people and also to enable emailing from this Excel. However I dont want to send the mail from the Excel, rather I want to open up a blank email with required addresses in To and CC in Lotus Notes itself.

I have used the Hyperlink option to send mail to a limited no of people, if the no. of recepients is high then this method is not working. So I want to do the following:
1. Create a Group in Sender's address book on Local and add the required addresses in that group
2. If the group is already existing then edit the group to have the latest people in the group.

Does anybody know how to do achieve this !

Question by:Shanku_Makka
    LVL 63

    Accepted Solution

    LVL 1

    Assisted Solution

    Have you thought about creating your "address list" in Excel and importing it into the local address book or a group in an "self-made" database?

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    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.
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    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…
    This video discusses moving either the default database or any database to a new volume.

    729 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