E-mail to more than one recipient

[60john]

Hi there,


I need help with sending mail to three recipients in the "to" field in the below code.

I have tried separating the addresses with ; and , but did not work. Nor did enclosing in brackets or using the "Array("mail1", "mail2", "mail3") format.

With OutMail
            .to = ""
            .CC = ""
            .BCC = ""
            .Subject = ""
            .Body = ""
            .Attachments.Add ActiveWorkbook.FullName
            .Send
        End With

Any help is appreciated.

 

[mick0005]

.To = "address1@domain.com;address2@domain.com;address3@domain.com"

 

[60john]

.To = "address1@domain.com;address2@domain.com;address3@domain.com"

Thanks mick0005. That worked a treat.

 

[mick0005]

Great!