Lotus Notes - Can't do multiple "Send Tos"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've read a few threads about how to use VBA to send an email via LotusNotes, complements of Andy Wiggin
(http://www.microsoft.com/office/com...ming&mid=f4a0d4d3-74af-4a62-b09a-31090607784e

However, whilst it works fine for one recipient in each of the "SendTo", "CC" and "BCC" fields, it does not work for, say, 2 recipients in the "SendTo" field

For example, I have tried setting the EmailSendTo variable (please see above post) to "(e-mail address removed), (e-mail address removed)", but the email only gets sent to "(e-mail address removed)"..

How can I rectify this

Many thanks for your suggestions

SuperJas.
 
Hi SuperJas,

I haven't worked with Notes much, but you could try either 1) separating the
email addresses with semicolons (" (e-mail address removed) ; (e-mail address removed) ") or 2)
using array(" (e-mail address removed) ", " (e-mail address removed) "). One of those may do the
trick.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
I've ran into this same problem. I solved it by creating a mailing
list in my Notes address book, then using the mailing list name in the
SendTo field.

This sends the emails and attachments to all members of the mailing
list.

- Matty


Jake Marx said:
Hi SuperJas,

I haven't worked with Notes much, but you could try either 1) separating the
email addresses with semicolons (" (e-mail address removed) ; (e-mail address removed) ") or 2)
using array(" (e-mail address removed) ", " (e-mail address removed) "). One of those may do the
trick.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Hi,

I've read a few threads about how to use VBA to send an email via
LotusNotes, complements of Andy Wiggins
(http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.p
ublic.excel.programming&mid=f4a0d4d3-74af-4a62-b09a-31090607784e)

However, whilst it works fine for one recipient in each of the
"SendTo", "CC" and "BCC" fields, it does not work for, say, 2
recipients in the "SendTo" field.

For example, I have tried setting the EmailSendTo variable (please
see above post) to "(e-mail address removed), (e-mail address removed)", but the email only
gets sent to "(e-mail address removed)"...

How can I rectify this?

Many thanks for your suggestions,

SuperJas.
Click to expand...
Click to expand...
 
This is the solution:

Dim EMailSendTo As Variant
EMailSendTo = Array("(e-mail address removed)", "(e-mail address removed)")

:)
Byeee
 
This is the solution:

Dim EMailSendTo As Variant
EMailSendTo = Array("(e-mail address removed)", "(e-mail address removed)")

:)
Byeee
 
Back
Top