VBScript, Outlook Application Object problems

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

VBScript, Outlook Application Object problems

Logged in as: Guest

arrSession:exec spGetSession 2,2,552

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> VBScript, Outlook Application Object problems
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

VBScript, Outlook Application Object problems - 1/9/2002 5:06:50 PM

stuarttw

Posts: 2
Score: 0
Joined: 11/16/2001
From: USA
Status: offline

I have this application using VBScript that simply creates an Outlook application object and, using the namespace and folder objects, runs through a specified folder, grabs the data and inserts it into a SQLServer database. All of that works SPLENDIDLY.

However... on some machines (particularly those hooked to an Exchange server that has a hugmangous contacts folder) that process could take quite some time. So, I decided to add an ActiveX progress bar to the page.

The control bar works great when it is stand-alone, but when added to the VBScript code that accesses Outlook, it will only paint the progress bar status BEFORE the loop starts through the contacts folder and after the whole process is over (jumping from 0 to 100% with a several-minute pause in-between). That obviously won't work - so, to make sure it wasn't an ActiveX problem, I put in code that simply wrote text to the page during each iteration of the For loop in the contacts folder. The same thing happened.

Funny, though, if I make a msgBox pop up during each iteration of the loop, THEN the text is printed (or the progress bar shows its current progress).

SO, that said, is there some way to FORCE the code to show the text or paint the progress bar status without having to pop up some sort of msgBox? I'm guessing it's because the application object is working, and nothing gets displayed to the browser until the outlook object is complete. How do I remedy this?

Thanks all!
Stuart
Washington, DC