Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending Lotus Note thru MSAccess

Status
Not open for further replies.

batteam

Programmer
Sep 12, 2003
374
US
I am sending a Lotus Note using VBA code behind a MSAccess 2007 form. All works great, except now I want to send to more than one recipient in the 'Copy To' part of the process. A snippet of my code is:
...
...
Call objNotesMailDoc.ReplaceItemValue("SendTo", strRecipient)
Call objNotesMailDoc.ReplaceItemValue("CopyTo", strCCRecipient)
Call objNotesMailDoc.ReplaceItemValue("Subject", strSubj)
Call objNotesMailDoc.ReplaceItemValue("Body", strBody)
...
...
How can I value the variable strCCRecipient so it will send the Note ("CopyTo") to two (or more) recipients? Thanks in advance for any help you can offer.
 
As I recall, you just comma separate the addresses:
Code:
strRecipient="user1@example.com,user2@example.com,user3@example.com"

but it's been a while since I had Lotus Notes on my machine. If that doesn't work, try using a semi-colon instead of a comma.

hth

Ben

----------------------------------------------
Ben O'Hara
David W. Fenton said:
We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top