Results 1 to 8 of 8
  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

    Random Send and Receive (OL 2003)

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

    Is there a way that I can set the Send/Receive command to start with a randomly chosen account?

    Say I have 10 e-mail accounts that I use OL to download messages from. Currently OL accesses these accounts in the order that they were entered. You do have some control over this order, but this is not what I am looking for.

    I want OL to start with account 1, 2, 3, 4,... 10 this time, but next time, I want it to start 3,7,2,6, 10..1 then the next time, 9, 8, 2, 10, 3, ...7 and then the next time I get my e-mails it should start with 5, 8, 10, 1, 2, ...9.

    The best solution is that it will start with the account with the most messages, each time going from most to least.

    Any VBA, or some 3rd party add-in you know about?

    Thanks a lot

    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
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Random Send and Receive (OL 2003)

    "The best solution is that it will start with the account with the most messages, each time going from most to least."

    Outlook would NOT know the message count until the account was opened. So do you want Outlook to go a get the message count from each account, and then go back and start downloading from the different accounts?

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  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: Random Send and Receive (OL 2003)

    While computer science has invented many ways to randomize numbers, I don't think even the best minds have yet found a way to change the account Outlook will send out on using VBA -- except with an ugly kludge like SendKeys. Was that implicit in your question, or have you solved that problem? If so, many people would love to know how.

  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: Random Send and Receive (OL 2003)

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

    <<< Outlook would NOT know the message count until the account was opened. >>>

    Yes I knew that, so you are right when you said <<< do you want Outlook to go a get the message count from each account, and then go back and start downloading from the different accounts? >>>

    This will be a great thing to be able to do. We have about 90 accounts, some have 2 messages per day, some 9000 messages per day. I have sent OL to automatically download each 1 hour, and some times it takes longer than an hour to download 9000 messages.

    So when this happens, the whole process suffers. I am sure we can process some messages as the bigger accounts are downloading, thus streamlining the whole process and getting to the processed messages just a bit faster.

    I have a second question, so please be on the look out.

    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: Random Send and Receive (OL 2003)

    <img src=/S/flee.gif border=0 alt=flee width=25 height=25> Jefferson

    No I need a solution ASAP. See my reply to Dave.

    Randomizing is not really what I am looking for, but acctually some sort of check, and determination. Not simply a randomized number that reflects the account.

    After all, even with the random number of the account, you still can end up with the fatest account.

    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>

  6. #6
    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: Random Send and Receive (OL 2003)

    Sorry, I was thinking about the sending part, rather than the receiving part....

    If Outlook and/or CDO cannot retrieve then number of message in queue on the mail server, there are third party controls that you can use to interact with POP3 and IMAP mail servers. These are COM objects that you can automate like any others. For Exchange, I'm not aware of any add-ons, but I'm sure they exist!

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

    Re: Random Send and Receive (OL 2003)

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

    Do you recommend any one in particular?

    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>

  8. #8
    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: Random Send and Receive (OL 2003)

    > Do you recommend any one in particular?

    No, I've never actually bought any of them. We have had some threads on COM objects/ActiveX controls for mail in the past, and I was just looking stuff up at VBxtras or other sites that sell a lot of these products. (If you get MSDN magazine, you'll see ads in there, too.)

Posting Permissions

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