control Outlook Address book from Excel VBA

PhilM

Guest

Posts: n/a

17th Oct 2007

I have a spreadsheet that mails via outlook automatically. At the
moment the user has to type in the email address of the recipient via
an input box. How can I get VBA to open the outlook address book
similar to sending an email via outlook normally?

« control Outlook Address book from Excel VBA | Adding a new Sheet but not making it the Active Sheet »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
control Outlook Address book from Excel VBA	PhilM	Microsoft Excel Programming	0	17th Oct 2007 01:59 PM
Address Book control SharePoint and Outlook 2007	victor.shamanovsky@gmail.com	Microsoft Outlook Discussion	1	20th Nov 2006 05:24 PM
Using Outlook address book in Excel	=?Utf-8?B?RGlhbmUgSGF6ZW4=?=	Microsoft Excel Misc	1	19th Apr 2005 08:39 AM
outlook address book in excel	zia	Microsoft Excel Misc	3	1st Mar 2004 04:21 PM
How do I import Windows Address Book entries into the Outlook 2003 Address Book?	Mark	Microsoft Outlook	2	3rd Jan 2004 06:32 PM