Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Can i use Outlook contacts in Word (http://www.outlookbanter.com/outlook-vba/47216-can-i-use-outlook-contacts.html)

Oggy April 30th 07 08:57 PM

Can i use Outlook contacts in Word
 
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] April 30th 07 09:20 PM

Can i use Outlook contacts in Word
 
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.

--
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/


"Oggy" wrote:

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




All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com