Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    Western Massachusetts, USA
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MSOutlook vs. FirstClass (A2K)

    This is a two part question. First, I am trying to email a message in Outlook based on an event in Access. Now I can't use SendObject because OutlookExpress is not my default email. FirstClass is. So I am trying to use OutLook to do the emailing. Now I've got it working as far as
    myOLItem.Display
    myOLItem.Send
    Outlook opens and displays the message but doesn't send the message because there isn't enough time to complete the process before the code moves on. I think it's because the School uses FirstClass as the default email server and Outlook only gets the leftover time. Therefore it can't complete the process. It moves the mail to the Outbox and it never gets sent until I open Outlook manually. What I'm looking for is a way to pause the code long enough to complete the process, about 5 seconds. The code is in a module and not an event so I don't think the Timer Event will help at all. Anyone have some thoughts on pausing code for a certain duration.
    The second question is
    Does anyone out there use FirstClass. I'd like to find anyone familiar with marrying FirstClass to Access.
    Thanks
    Paul

  2. #2
    Lounger
    Join Date
    Feb 2001
    Location
    TX, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSOutlook vs. FirstClass (A2K)

    try this. I use it in modules with no problems

    Function fnMomentaryPause(timPause As Single)

    Dim Start
    Start = Timer ' Set start time.
    Do While Timer < Start + timPause
    DoEvents ' Yield to other processes.
    Loop

    End Function

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Location
    Western Massachusetts, USA
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSOutlook vs. FirstClass (A2K)

    Hi Jim. That's seems to have done the trick. I'll test it a little more but the first 2 runs were great. Thanks
    Paul

Posting Permissions

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