Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    User Notification (Outlook 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    OK what is the best way to inform the user of what is going on while the VBA code is running?

    I can use MsgBox but that will stop the code until the dialog is dismissed. I tried looking at the Status Bar, but it does not seem like its open for user/developer.

    What else can you suggest?

    Thanks a Million.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Notification (Outlook 2000)

    You might create a UserForm and run the code from the form. You can inform the user by changing the caption of a label, for instance. Your may have to refresh the form frequently - see the problems in the thread starting at <post#=288869>post 288869</post#>.

  3. #3
    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: User Notification (Outlook 2000)

    With Office 2000 and higher you can use a modeless UserForm.

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: User Notification (Outlook 2000)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Jefferson

    Honest to God, I thought that the developers of Outlook 2000 have missed some major points.

    My God it must be true that the Office component programming teams did not talk to each other while working on the components.

    I tell you, this bit about the seamless transition between the applications should also extend to developers too.

    Or is Office 2003 what I am looking forward to?

    I ended up developing a neat user form, and this form is what I am using to run the code and display the info for the user.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: User Notification (Outlook 2000)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hans

    I ended up working on a User Form, and it works OK with a lot of repainting.

    Every time I loop and grab a new message I have to pass the subject and from, and to fields to the userform. That is working OK, but very slow.

    OK so we will wait until Office 19 to get what we really want today <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Thanks again.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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