HELP!!! Send email from Access 2000

[AnnYH]

Hi, Experts:

There is a problem about sending email from Access. It bothers me a long time.

Is there any one can help me?

Sub SendEmail()
Dim strEmail as string
Dim strSubject as string
Dim strMsg as string

strEmail= "accnt@hotmail.com"
strSubject = "New Client Notice..."

'Send email
strMsg = "New Client Name: " & NewClientName & SPACE & SPACE & Me.CityEmployeeName

DoCmd.SendObject acSendNoObject, , , strEmail, , , strSubject, strMsg

End sub

I can use this code to send email from my desktop.It works perfectly.

But on some user¡¯s computer, it can be work. Always said:
¡°The program has performed an illegal operation and will be shut down.¡±
¡°MSAcess.exe caused an invalid page fault in KERNEL32.dll at ¡­¡±

I checked Microsoft site I did everything that I can. This problem is still there.

It drive me nut.

Help me, please!!
Thanks all.

AnnYH

 

[FancyPrairie]

I was having the same problem today. I did a search on Google and came upon a couple sites that explained the problem. One reason why we get the invalid page fault is because are message string is greater than x number of characters. I changed my from 93 to 50 and it worked. However, I got an issufficient memory problem after the mail was sent. But found this article and tryed it and it works great.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q161088&