Results 1 to 4 of 4
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Using OL Contacts to insert addresses in Word (English/Word2003/SP1)

    Did you see if

    Word.Application.GetAddress

    defaults to Outlook Contacts?

    (Since Office XP, MS has been steering users away from Personal Address Books - consider asking users to import them into Contacts and cease using them.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  2. #2
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Using OL Contacts to insert addresses in Word (English/Word2003/SP1)

    Hi John,

    I was using WordBasic.InsertAddress, so I tried your suggestion instead and the same thing happened - the Outlook Address Book appears, but still defaults to our Global Address List. Not a biggie really, just a case of the user picking up their Contacts folder (they do use Contacts rather than Personal Address Books).

    Many thanks!

    Violet

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Using OL Contacts to insert addresses in Word (English/Word2003/SP1)

    I see, GetAddress works with the default OAB, and so the GAL is coming up since many users & IT admin set it as default. If you need to get the address from User Contacts, the code is going to get more complex.

    See if anything in these threads helps:

    <post#=310,857>post 310,857</post#>
    <post#=324,474>post 324,474</post#>
    <post#=244,856>post 244,856</post#> (except you would use Outlook.GetNamespace("MAPI").GetDefaultFolder(olFo lderContacts) instead of the named GAL.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Using OL Contacts to insert addresses in Word (English/Word2003/SP1)

    Edited by <!profile=StuartR>StuartR<!/profile>, long row of - characters replaced with <!t>[black line]<!/t><!t>[black line]<!/t> to prevent excessive page width

    Ok, I've now figured out how to insert an address using contacts, however, might anyone know how to make the list automatically default to the Contacts folder, rather than the internal Outlook Address Book entries?
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

    Hi everyone,

    We have a template for a letter (which was created as far back as Word97) and we used to use the following VBA to allow users to insert addresses into their letter from their Outlook Contacts:

    If TxtAdd1 = "" Then
    Selection.GoTo What:=wdGoToBookmark, Name:="add1"
    MsgBox "You should now choose the address you want to use"
    WordBasic.InsertAddress
    DisplaySelectNamesDialog
    'otherwise go to start
    Else
    Selection.GoTo What:=wdGoToBookmark, Name:="Start"
    End If

    Since moving to Word2003, we encounter a debug error at the "DisplaySelectNamesDialog" line. I've searched the Help (which seems to be awful with Word2003 compared to previous versions!) and can see it's possible to use Outlook Contacts when creating envelopes and labels, but that's the only mention.

    I'd be grateful if anyone could shed any light. Many thanks!

    Violet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •