I should have found the solution and now it seems to work correctly always.
I just cut out from the code this row:
Set MyMail = Nothing
I don't know why, i'm not a real technician, but it's good :))
Bye all
I should have found the solution and now it seems to work correctly always.
I cut out from the code these two rows:
Set MyMail = Nothing
Set MyOutlook = Nothing
and "activated" this:
MyOutlook.Quit
I don't know why, i'm not a real technician, but it's good :))
Bye all
The user writes the subject in the form and have to choose a HTML file as the body message.
That's the code:
____________________________
Sub SendEMail()
Dim MyOutlook As Outlook.Application
Dim MyMail As Outlook.MailItem
Dim BodyFile As String
Dim fso As FileSystemObject
Dim MyBody As...
Hi everybody,
i'm using a routine which sends emails from Access and it seems to work great. Ok.
But...
my system hangs when i use it. I mean, the routine starts but Access freezes while sending.
I have to go in the Task Manager, stop Outlook, so that Access recovers but without sending...
Hi spop,
i've used your code and it seems to work great. Thanks!!
But...
Most times my system hangs when i use it. I mean, the routine starts but Access freezes while sending.
I have to go in the Task Manager, stop outlook, so that Access recovers but without sending.
I tried to set the task...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.