MSOutlook vs. FirstClass (A2K)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote