Re: create loop through three recipients email addresses by fitful_thought
fitful_thought
Sat Oct 30 17:01:37 CDT 2004
Ray,
Thank you very much for that.
It's exactly what I was trying to achieve.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%230qOKVqvEHA.1204@TK2MSFTNGP10.phx.gbl...
> Assuming I understand what you're asking:
>
>
> Dim aRecip(2)
> aRecip(0) = "joe@domain1"
> aRecip(1) = "bob@domain2"
> aRecip(2) = "kate@domain3"
>
>
> .From = sFrom
> .Sender = sSender
> .Bcc = sBcc
> .Subject = sSL
> .HTMLBody = strHTML
> For i = 0 To UBound(aRecip)
> .To = aRecip(i)
> .Send
> Next
> End With
>
> Ray at work
>
>
>
>
> "fitful_thought" <cascando@legs.com> wrote in message
> news:u%23ZtZzkvEHA.3376@TK2MSFTNGP12.phx.gbl...
>> With iMsg
>>
>> Set .Configuration = iConf
>>
>> .To = sRecipients
>>
>> .From = sFrom
>>
>> .Sender = sSender
>>
>> .Bcc = sBcc
>>
>> .Subject = sSL
>>
>> .HTMLBody = strHTML
>>
>> Next
>>
>> End If
>>
>> .Send
>>
>> End With
>>
>> -----------------
>>
>> How do I create loop through three recipients email addresses, one at a
>> time?
>>
>>
>>
>>
>
>