Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

SysExpert earned 500 total points
ID: 16629924

Assisted Solution

freednerd earned 500 total points
ID: 16681196
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month14 days, 3 hours left to enroll

581 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