Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / April 2007

Tip: Looking for answers? Try searching our database.

Can i use Outlook contacts in Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Oggy - 30 Apr 2007 19:57 GMT
Hi,
I use Outlook as my main database for contacts numbers ,address etc...
Does anyone know how i can get a selected persons address from
Outlook  using  a userform in Word, Or an easier alternitive?

Thanks

Oggy
Eric Legault [MVP - Outlook] - 30 Apr 2007 20:20 GMT
How is this person selected?  If they are selecting a Contact in Outlook, you
can use the Explorer.Selection object to return a Contact object (or more)
for the selection.

If all you have is a name from a custom list or something, you can try
retrieving the Contact object by using MAPIFolder.Items("John Doe").  You can
also use the Items.Restrict method to search items in that folder using any
property you want.

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> Hi,
> I use Outlook as my main database for contacts numbers ,address etc...
[quoted text clipped - 4 lines]
>
> Oggy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.