sending an email to more than one CC recipient

[humvie]

I have the following code that works fine if I have only one email address but want to sometimes include more than one address. The addresses are stored in a table and retrieved through a form when a customer is selected. Text91 and Text87 (are both on the form).

.To = StrEmail
    Do While Not rsCC.EOF
    strCC = Nz(Text91) 'and Nz(Text87)
       .CC = strCC
    End If
    rsCC.MoveNext
    Loop
    rsCC.Close
.BCC = "address2@hotmail.com"
.Subject = "topic of discusion"
.Body = "Text goes here..."
.Send

Thanks in advance for your help.

 

[JonFer]

This has been answered in a post earlier this month. Try searching for the topic.

 

[nat1967]

Hi humvie,

I answered a similar question in another thread. check it out and let me know if it helps.

thread702-709010


Have A Great Day!!!,

Nathan
Software Testing Lead

http://www.skylineprints.com