|
| 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 
|
| Ads |
|
#2
December 22nd 09, 09:16 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Using name from address book in lieu of actual email address
Don't add email addresses but names, then call the ResolveAll function. If the names can be resolved, you will see the DisplayNames. A name can be resolved if there's exactly one e-mail address for the name. -- Best regards Michael Bauer - MVP Outlook Manage and share your categories: http://www.vboffice.net/product.html?pub=6&lang=en Am Mon, 21 Dec 2009 22:44:01 -0800 schrieb OssieMac: 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
|
|
#3
December 23rd 09, 12:10 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Using name from address book in lieu of actual email address
Thank you Michael. It is so easy. I just could not find the right word/s when
trying to look it up. -- Regards, OssieMac "Michael Bauer [MVP - Outlook]" wrote: Don't add email addresses but names, then call the ResolveAll function. If the names can be resolved, you will see the DisplayNames. A name can be resolved if there's exactly one e-mail address for the name. -- Best regards Michael Bauer - MVP Outlook Manage and share your categories: http://www.vboffice.net/product.html?pub=6&lang=en Am Mon, 21 Dec 2009 22:44:01 -0800 schrieb OssieMac: 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 .
|
| 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 |
Linear Mode
