Running process in the Background

[RLN]

Re: Access 2003
The FE is on the workstation and the BE is on the file server. Right now
the system only has 2 concurrent users.

I have a process in my application that sends out email confirmations
internally in the company that indicate that the processing of their
financial transactions has completed. Generally when the user runs this
code module to send the emails, it might take 2 to 3 minutes, depending on
the number of emails that need to be sent out.

Right now the user cannot do anything else in the app until this process
gets done.

Is there some VBA code I can add that would run the email sending process in
the background so the user can continue using other parts of the application?


Thanks...

 

[Stefan Hoffmann]

hi,

Generally when the user runs this
code module to send the emails, it might take 2 to 3 minutes, depending on
the number of emails that need to be sent out.

How do you send e-mails?

Is there some VBA code I can add that would run the email sending process in
the background so the user can continue using other parts of the application?

No easy way without a lot of extra coding.


mfG
--> stefan <--

 

[RLN]

No easy way without a lot of extra coding.<<

Do you have an exmaple where his is done?

 

[dch3]

What code are you using to send the emails? Are you using
CreateObject("Outlook.Application") to create the items directly in Outlook?

 

[Stefan Hoffmann]

hi,

Do you have an exmaple where his is done?

As you cannot use threads in Access directly, you need to code an extra
program for that.

btw, you haven't answered my first question. The time it takes is not
normal. I strongly believe that your code is not clean. Otherwise if it
is, then you have a general e-mail problem.


mfG
--> stefan <--

 

[RLN]

This is a small snippet of how I am setting up the email to send.
Dim olApp As Outlook.Application
Dim olMail As MailItem
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)