Replies

Wow Laura, it looks great. I’ll try this today and report back on my results.

Thanks,
Kim

Hi Laura,

You know, I started out accessing Outlook objects directly. I built an array of all names in my chosen contact folder and displayed them in a listbox. At the same time, I also loaded various fields into the same array as well, then closed the instance of Outlook as soon as the list box (and array) was populated. Then when I chose my contact(s), the data was already in memory and it executed very quickly. But it’s quite time consuming to load the fields into the array — I have about 350 and it took anywhere from 15 to 30 seconds to complete loading, which is a long time for the user to wait.

On the other hand, perhaps I could approach it as I was trying to do with the GetAddress method — to populate the listbox with the display names only and close the instance of Outlook. Then once the user has chosen his To:, cc: and bcc: names, the code would open a new instance of Outlook and pull the address data only for the chosen To: recipients. I’ve done something like this with an Access database, so I can probably adapt that logic to this. I think the user is more likely to tolerate a little lag once they’ve chosen their contacts, plus I’d only be pulling the data they want, not all data — which would make it more efficient.

I’ll give that a try and will be sure to let you know how it turns out.

Thanks for the brain boost!
Kim

Hi Laura,

You know, I started out accessing Outlook objects directly. I built an array of all names in my chosen contact folder and displayed them in a listbox. At the same time, I also loaded various fields into the same array as well, then closed the instance of Outlook as soon as the list box (and array) was populated. Then when I chose my contact(s), the data was already in memory and it executed very quickly. But it’s quite time consuming to load the fields into the array — I have about 350 and it took anywhere from 15 to 30 seconds to complete loading, which is a long time for the user to wait.

On the other hand, perhaps I could approach it as I was trying to do with the GetAddress method — to populate the listbox with the display names only and close the instance of Outlook. Then once the user has chosen his To:, cc: and bcc: names, the code would open a new instance of Outlook and pull the address data only for the chosen To: recipients. I’ve done something like this with an Access database, so I can probably adapt that logic to this. I think the user is more likely to tolerate a little lag once they’ve chosen their contacts, plus I’d only be pulling the data they want, not all data — which would make it more efficient.

I’ll give that a try and will be sure to let you know how it turns out.

Thanks for the brain boost!
Kim

Well, DUH!

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…?

Thanks, all
Kim

Well, DUH!

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…?

Thanks, all
Kim

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

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

I’m guessing the latter.

I did a little more digging and indeed there seems to be something that makes a document created through the Word interface know it’s labels (look at the temp document name Word gives it). It could be as simple as having a label definition associated with it in some fashion. One could probably find the VBA code to do this, but… I’ll leave that to someone with a longer attention span.

Cheers!
Kim

I’m guessing the latter.

I did a little more digging and indeed there seems to be something that makes a document created through the Word interface know it’s labels (look at the temp document name Word gives it). It could be as simple as having a label definition associated with it in some fashion. One could probably find the VBA code to do this, but… I’ll leave that to someone with a longer attention span.

Cheers!
Kim

Hey Jefferson!

My global template is in c:program filesmicrosoft officeoffice10startup. That folder has been cited as one “Trust all installed add-ins…” will recognize.

However, thanks to your question, I looked in Word’s File Locations and saw that Startup was pointed to a startup folder under my documents and settings. This is a default setting and it never occurred to me to question it since the templates about which I was complaining were loading. This was as a result of being in the “common” startup folder, but they were not being trusted because they were not in the folder specified in Word. !!!!

Once I changed the reference in the File Locations and reopened Word, all worked! I didn’t even have templates in my personal startup folder as I didn’t really know it was there.

Live and learn. And thanks so much…
Kim

Hey Jefferson!

My global template is in c:program filesmicrosoft officeoffice10startup. That folder has been cited as one “Trust all installed add-ins…” will recognize.

However, thanks to your question, I looked in Word’s File Locations and saw that Startup was pointed to a startup folder under my documents and settings. This is a default setting and it never occurred to me to question it since the templates about which I was complaining were loading. This was as a result of being in the “common” startup folder, but they were not being trusted because they were not in the folder specified in Word. !!!!

Once I changed the reference in the File Locations and reopened Word, all worked! I didn’t even have templates in my personal startup folder as I didn’t really know it was there.

Live and learn. And thanks so much…
Kim

Yippee!!

And being an Excel novice, even seeing the data did me no good at all…

I am much better educated having gone through this. Thank you, thank you, thank you, etc.

Kim

[Edited to include extra info]

Here is the file. And here is its history:

Originally a WordPerfect table.
Used Save As in WP to save as Excel 4.0 spreadsheet.
Opened in Excel XP and saved as current version spreadsheet.
There are two named ranges that I’ve been testing – _author which is just the first column and _authors which is all columns

The code from MVP refers to “Excel 8.0” but if I change to later version, I’m told I don’t have an appropriate ISAM.

[Extra info:] The problem seems to lie in the file. I created a new Excel file and the code worked on it. On the other hand, I am able to display all rows if the named range only consists of one column (the _author range). Aarrrrgghhhh.

So there we are…

Thanks so much,
Kim

Hi Hans,

I filled the blank row with field names and stepped through the code again. The NoOfRecords variable is getting set accurately, but only the first row of data is being displayed. I even redefined my named range, but I still only return the first row.

If I use the identical code, but SELECT * FROM a named range consisting only of the first column, I do get all rows returned, but am I correct that I have not loaded all the info in the other columns (and outside the named range) into memory?

Thanks again,
Kim

Hi again!

[Edited to add further question]

I had the reference right. I had the quotes wrong. *Backwards* quotes! Made all the difference.

[Further Question:] I am having some odd problems displaying the data now. Remember that I said I had no header row. If I don’t include a blank row at the top of my Excel spreadsheet, and then include the blank row in my named range, I don’t capture the first record.

If I define a range of the first column only and all 12 rows, I see every record in my listbox. Hurray!
If I define a range of the 6 columns and 12 rows, I display only the first record in my listbox. Hmmm. This is better than before, when I got nothing (then I added the blank row at the top of the range…) There are only so many things to tweak so I’m at a bit of a standstill.

Any ideas of what I may be missing?

Thanks Hans!!
Kim