|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 5th 10, 01:55 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
| Ads |
|
#2
January 5th 10, 02:11 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#3
January 6th 10, 05:42 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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 .
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can't load graphics in my email | Margaret Bartley[_2_] | Outlook - General Queries | 1 | October 23rd 09 03:05 PM |
| Prompt email subject line when creating a new email outlook 2003 | macster | Outlook and VBA | 1 | January 5th 09 02:04 PM |
| Load request form fails: Could not load some objects because they arenot available on this machine | [email protected] | Outlook - General Queries | 1 | August 5th 08 10:22 PM |
| Outlook 2007 takes forever to load graphics in an email | Corky D | Outlook - General Queries | 3 | June 4th 07 11:03 PM |
| How do I get the BCC line to always appear in a new Outlook email | Jennifer | Outlook - General Queries | 2 | May 30th 06 11:52 PM |
Linear Mode
