|
| 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
December 22nd 09, 07:44 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Using name from address book in lieu of actual email address
The following is an extract of code that I use to send emails from an Excel
program. How can I modify it to use peoples names as they appear in my address book in lieu of using their actual email address for .To, .CC and .BCC strTo = " 'Sample. Not valid email address strCC = " 'Sample. Not valid email address strBCC = " 'Sample. Not valid email address Set objMail = objOutlook.CreateItem(olMailItem) With objMail .To = strTo .CC = strCC .BCC = strBCC .Subject = strSubject .Body = strBody .DeleteAfterSubmit = True 'Does not save email in Sent mail folder. .Display .Send End With -- Regards, OssieMac 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2003 - Extract Actual Email Address from Received Email | Michael[_6_] | Outlook - General Queries | 2 | March 3rd 09 04:28 PM |
| Public Folders - Display Actual Address That Email Was Sent To | Art Vandelay | Outlook - General Queries | 3 | October 13th 06 05:49 AM |
| Outlook should alllow sorting address book by email address. | Henry Morgan | Outlook - Using Contacts | 1 | August 1st 06 07:48 PM |
| Outlook 2002 Uses email address not in Contacts or Address book | Pagen | Outlook - Using Contacts | 1 | February 1st 06 06:11 PM |
| Set which local email account can send mail to contacts in address book. (associating an email address with a contact) | Scott Streit | Outlook - General Queries | 3 | January 27th 06 03:57 PM |
Threaded Mode