Using VBA to load the CC line on an Outlook email

[Glenn Suggs]

Can someone please help me in loading the CC line in an email from VBA in
Access? I have the following for the "To" line that works fine. Is there an
equivalent statement to load the CC?

Dim olRecipient As Recipient
strEmailRecipient = "(e-mail address removed)"

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

Thanks in advance

 

[Ken Slovak - [MVP - Outlook]]

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)
olRecipient.Type = olCC ' or olTo or olBCC

 

[Glenn Suggs]

Thanks a million, Ken. It works great.