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.
...
...
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.