Link to home
Start Free TrialLog in
Avatar of Shanku_Makka
Shanku_Makka

asked on

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

Hi,

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 !

Thanks!
Samrat..
ASKER CERTIFIED SOLUTION
Avatar of SysExpert
SysExpert
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial