How to send mail to multiple recipents stored in a Variant?

Hi ,I m storing the names of all people who r suppossed to receive mails from an client application in a Variant and i want to send mails to all of them…

How do i do so??

Pls help…

Thanks in advance.

Subject: How to send mail to multiple recipents stored in a Variant??

use arrays … for that…remember New Domain Tracking System in which I had done the same…

cheers

kaushik das

Subject: How to send mail to multiple recipents stored in a Variant??

I think this will work:Call doc.ReplaceItemValue( “SendTo”, varSendTo )

else you have to

forall the variant and append each newValue with

call item.AppendToTextList( newValue )

or

forall the variant, put each value in a temp array and

call doc.ReplaceItemValue( “SendTo”, array )

VH

Subject: RE: How to send mail to multiple recipents stored in a Variant??

I checked and the below works fine:Call doc.ReplaceItemValue( “SendTo”, varSendTo )

doc is the memo document

“SendTo” is the SendTo field

varSendTo is your variant

VH

Subject: How to send mail to multiple recipents stored in a Variant??

Dear Khusi,

Use this code :

Redim mailID(0) As Variant

Dim item As NotesItem

Set item=doc.GetFirstItem(“MailIDs”)

x=0

j=0

Forall values In item.values

	mailID(x)=values

	Redim Preserve mailID(j To x+1) As Variant

	x=x+1

End Forall

Now all maill id’s in ur array list .Now by using one for loop u can send a mail to all person who is listed in ur field.

for i=0 to Ubound(mailID)-1

Call memo.Send( False,mailID(i))

Next i

Hope this help u . If any other probs is left u can free to mail me on :

(rishi_sahi2003@yahoo.co.in)

Rishi

Subject: Why waste all those lines of code like that???

Redim mailID(0) As Variant Dim item As NotesItem

Set item=doc.GetFirstItem(“MailIDs”)

x=0

j=0

Forall values In item.values

	mailID(x)=values

	Redim Preserve mailID(j To x+1) As Variant

	x=x+1

End Forall

You can do this in 1 line:

mailIDs = doc.GetItemValue(“MailIDs”)

Subject: Thanks

Thanks a lot everyone…Right now i m using an array to capture all the id’s and then sending mails to all…This is working fine.

I’ll check using the other methods that u’ve posted…

Thanks once again.

Khushi