Results 1 to 6 of 6
  1. #1
    5 Star Lounger kmurdock's Avatar
    Join Date
    Feb 2003
    Location
    Pacific Grove, California, USA
    Posts
    716
    Thanks
    10
    Thanked 34 Times in 28 Posts

    Outlook Integration with Word (Office XP/SP2)

    Using code in an article from the MSDN Library, I've created a couple of forms in Word that are populated by Outlook contacts (article is "Insert Outlook Contact Information Into Word Documents" July 2000 by Mike D. Jones).

    When I first created it, I kept erroring out. Turns out it was choking on a Distribution List -- didn't like that at all. Since the list was a test left over from something else, I deleted and all went well.

    My question is this. Is there any way to speed it up?

    I have 350 contacts and this form takes anywhere from 5 seconds (fastest) to 30 seconds (slowest) to populate. I am running Windows XP on a Satellite Pro laptop with all the patches. The fact that it sometimes goes very quickly and sometimes doesn't seems to indicate that it may be sharing computing time with something else. But I'm definitely a single-tasker, especially when programming. Maybe the O/S is doing something in the background? Are there any ways to tell the computer to ignore other requests while compiling the contact array?

    The code is populating an array with about a half dozen fields of info from each contact. I am now sorting the initial list of contacts (by the FileAs field), but it was slow before I started sorting and isn't that much slower now.

    Any thoughts? I have attached a zip of my template, the code in which is superfically different than the code in the article. When I used the exact code from the article, I got the same time delays.

    Thanks!
    Kim

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Outlook Integration with Word (Office XP/SP2)

    I'd guess that it has to do with what pieces of Outlook and the PST are in memory at any given time. After all, nothing else is changing, right? Except for a major RAM update, I'm not sure there's a practical solution to this one.

  3. #3
    5 Star Lounger kmurdock's Avatar
    Join Date
    Feb 2003
    Location
    Pacific Grove, California, USA
    Posts
    716
    Thanks
    10
    Thanked 34 Times in 28 Posts

    Re: Outlook Integration with Word (Office XP/SP2)

    J! You look so different without your sunglasses...

    Darn! I was hoping for a little O/S magic. By the way, what is the PST? There are too many TLAs for me to keep track of.

    Thanks,
    K

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Outlook Integration with Word (Office XP/SP2)

    I've no idea what the letters stand for, but a PST file is a file containing Outlook Personal Folders, otherwise known as an Outlook Data File.

    StuartR

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

    Re: Outlook Integration with Word (Office XP/SP2)

    Personal STorage file, a file that in typical Exchange installations holds a users permanent information. I didn't chime in because my experience agrees with Jefferson's comment, namely, that if the code and data being used is in the cache, it runs much faster than if not. See if the code runs any faster if you:

    Dim oItms As Outlook.Items

    (I didn't test.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    5 Star Lounger kmurdock's Avatar
    Join Date
    Feb 2003
    Location
    Pacific Grove, California, USA
    Posts
    716
    Thanks
    10
    Thanked 34 Times in 28 Posts

    Re: Outlook Integration with Word (Office XP/SP2)

    Well, DUH! <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    OK... in most cases, and as far as I know, the .pst file isn't doing anything else. I would buy that it's caching except that it doesn't get progressively or suddenly faster. It keeps varying.

    I will try John's suggestion (I thought I already did, but I could be quite mistaken) and report back.

    Perhaps someone knows a more efficient way of accessing Outlook...? <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>

    Thanks, all
    Kim

Posting Permissions

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