Using VBA to load the CC line on an Outlook email

Status
Not open for further replies.
G

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 = "someone@someplace.com"

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

Thanks in advance

Glenn
 
K

Ken Slovak - [MVP - Outlook]

Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

olRecipient.Type = olCC ' or olTo or olBCC

"Glenn Suggs" <GlennSuggs> wrote in message

news:F1BD68F1-545A-40B1-9229-1D16609F77D0@microsoft.com...
> 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 = "someone@someplace.com"

> Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)

> Thanks in advance
> > Glenn
 
G

Glenn Suggs

Thanks a million, Ken. It works great.

Glenn
wrote:


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

> >

>

> "Glenn Suggs" <GlennSuggs> wrote in message
> news:F1BD68F1-545A-40B1-9229-1D16609F77D0@microsoft.com...
> > 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 = "someone@someplace.com"
> > Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)
> > Thanks in advance
> > > > Glenn


> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
S Find a cell value in excel using outlook vba Using Outlook 1
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
B query outlook using vba Outlook VBA and Custom Forms 13
P Replying to calendar item using VBA Outlook VBA and Custom Forms 4
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
U Using VBA to creat hyperlinks in an email Outlook VBA and Custom Forms 3
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
Diane Poremsky Create a Series of Tasks using VBA New Slipstick.com Articles 0
Diane Poremsky Paste clipboard contents using VBA New Slipstick.com Articles 0
Diane Poremsky Copy New Appointments to Another Calendar using VBA New Slipstick.com Articles 0
L Clear Offline (Task) Items using VBA Outlook VBA and Custom Forms 0
O How to set subject line in replies using VBA Outlook VBA and Custom Forms 1
O VBA rule on multiple computers using shared mailbox Outlook VBA and Custom Forms 1
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
J Using VBA to disable alerts / warnings Using Outlook 2
P Saving All Messages to the Hard Drive Using VBA Outlook VBA and Custom Forms 5
Diane Poremsky Create a list of color categories and merge or restore the list using VBA New Slipstick.com Articles 0
A Can i apply mail rules to inbox sub folders using VBA Outlook VBA and Custom Forms 2
M using Folders.Count in Excel Vba Outlook VBA and Custom Forms 8
M VBA Send Sales reports using .oft files, originate in Outlook or Excel? Using Outlook 5
A Outlook VBA - moving mail item to public folder using variable within path Using Outlook 6
P Automatic reply on incoming messages in outlook using VBA(only Specifi person) Using Outlook 14
D Update existing rule using VBA Using Outlook 2
A VBA Script to Forward Spam to AntiSpam Provider Using "Blank" Form Outlook VBA and Custom Forms 2
J How to set a flag to follow up using VBA for outlook 2003 Using Outlook 10
J Add categories to Shared Mailbox using VBA Using Outlook 2
R Limiting meeting attendees using VBA or an add-in Using Outlook 9
J Create new outlook task into task subfolder using vba Using Outlook 6
S Send All emails in Outbox and Quit using VBA Outlook VBA and Custom Forms 3
R Outlook and Access integration using VBA Outlook VBA and Custom Forms 1
U using VBA to set message sensitivity Outlook VBA and Custom Forms 1
D Using VBA to send Word document as body of message works in 2007, but not in 2003 Outlook VBA and Custom Forms 9
H Odd symbol when stripping characters using vba Outlook VBA and Custom Forms 3
P move folders in outlook using vba Outlook VBA and Custom Forms 1
E Extracting CC Email Address Using VBA Outlook VBA and Custom Forms 2
S write and format a piece of text in the body using vba Outlook VBA and Custom Forms 7
H Program "Click on Ribbon Button" Using VBA Outlook VBA and Custom Forms 1
A Accessing .pst folder in outlook using VBA Code Outlook VBA and Custom Forms 4

Similar threads

Top