Using VBA to load the CC line on an Outlook email
 

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 = "

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

Thanks in advance
--
Glenn

Using VBA to load the CC line on an Outlook email
 

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

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Glenn Suggs" wrote in message
...
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 = "

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

Thanks in advance
--
Glenn

Using VBA to load the CC line on an Outlook email
 

Thanks a million, Ken. It works great.
--
Glenn


"Ken Slovak - [MVP - Outlook]" wrote:

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

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Glenn Suggs" wrote in message
...
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 = "

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

Thanks in advance
--
Glenn

.