View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Lotus Notes - Can't do multiple "Send Tos"

Hi SuperJas,

I haven't worked with Notes much, but you could try either 1) separating the
email addresses with semicolons (" ; ") or 2)
using array("
", " "). 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]


SuperJas wrote:
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/comm...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 , ", but the email only
gets sent to "...

How can I rectify this?

Many thanks for your suggestions,

SuperJas.