email CC to multiple recipients

[Xbox]

How does one go about sending an email to more than one CC or BCC etc ...

.To = StrEmail
.CC = "address@hotmail.com" (add another email address here)
.BCC = "address2@hotmail.com"
.Subject = "topic of discusion"
.Body = "Text goes here..."
.Send

ie. I want to send an email to address@hotmail.com and address14@hotmail.com both as CC's.

Thanks

 

[NaKin]

.CC = "emailaddress1@hotmail.com; emailaddress12@hotmail.com"

Just add a semi colon between addresses

 

[Xbox]

many thanks Nakin, I figured it was something silly and easy sa that.

Thanks again

 

[Xbox]

Ooops,

Just realized my email addreses are stored. I likely need to use recordset.

Can someone straighten this code out for me.

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