msoutlook.org Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Get Contacts from Outlook to Excel Combo Box

 
Post new topic   Reply to topic    msoutlook.org Forum Index -> Outlook Program VBA
Author Message
RyanH



Joined: 26 Feb 2008
Posts: 1

PostPosted: Tue Feb 26, 2008 9:58 am    Post subject: Get Contacts from Outlook to Excel Combo Box Reply with quote

I am new to VBA, so any help on this would greatly be appriecated. I am
currently working on a project in Excel VBA. Is there a way to search
through Microsoft Outlooks Contacts with a Combo Box I have located on a
Worksheet and/of UserForm?

For example:

The user will begin to type a company name (Lets say they start with "A") in
the Combo Box and a list will appear below the combo box with all the company
names that begin with "A" in there contacts list. From there the user can
select a company and the following items will be needed: Company Name,
Contact Name, Address, Phone Number, Fax Number, and E-mail. These items
will be placed in cells on the worksheet the combo box is located.

Is this possible?

Thanks in Advance,
Ryan

Archived from group: microsoft>public>outlook>program_vba
Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
Resize Issue in outlook My custom compose form have Message control on the left side & my activex control on the right side (alongwith To, CC on the upper part). I have set "Resize with layout" property of Message control to unchecked. I want to resize my activex control to the

Synchronize Outlook Appointment Hi, I'm trying to perform between my application and outlook default calendar (which mimic the behavior like ActiveSync) I have face the difficultly on update the appointment with recurrence pattern. let said, I have a appointment with

Problem in outlook addin Hi , I have one outlook-addin and it was working fine with 2003 , it is not working in 2007 . once i click on the add in button outlook is crashing .. and it is crashing in pOuter, dwClsContext,

Popping up Outlook contact via API Is there a method of calling up a contact record in Outlook if a unique ID of the contact is known through some API? Is there some DDE method in particular?

Email from Word to Outlook Thank you in advance. I'm trying to email a document to Outlook from Word. I have a button in Word that says "Submit". I would like to be able to click that button and it automatically send my Word Doc. to a specific person in Outlook. Can this be done?
Post new topic   Reply to topic    msoutlook.org Forum Index -> Outlook Program VBA All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group