How to access Lotus Notes address book from Excel worksheet (VBA)
Posted on 2006-05-08
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 !