Emailing from Access 2000

[davidgewin]

I have a small helpdesk set up in Access 2000. When calls are received from clients, an email is sent to them giving them a call number etc.
The problem i have is that i can only email once from Access (i'm on a Win2k machine). Once i send one email, i have to restart Access to send another.
The code is simple enough finishing with the statement:

DoCmd.SendObject acSendNoObject, , , logcall, copyto, , title, msg

Can anyone pls help me?

 

[DougP]

I have great luck with this:

Dim message As String

message = " Please don't hesitate to Email or Call if you have any questions." & Chr$(10) & Chr$(13)
message = message & " Email : your_e-mail_here.com" & Chr$(10) & Chr$(13)
message = message & " Phone : 1 (999) 999-9999" & Chr$(10) & Chr$(13)
message = message & "" & Chr$(10) & Chr$(13)
message = message & " Thank you," & Chr$(10) & Chr$(13)
message = message & " Douglas Poston, MCP" & Chr$(10) & Chr$(13)
message = message & " BarcodeONE Corporation" & Chr$(10) & Chr$(13)

DoCmd.SendObject acSendNoObject, "", acFormatTXT, Me!Email, , , "Thank you for Downloading the Code39 DEMO font", message, True
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[davidgewin]

Hi Paul,

Thank you for the reply.

My issue is not the formatting of the message, that's fine.

My issue is that when i use the button to email a message from Access, if i want to email another one in the same session, i can click the button repeatedly but nothing happens. I have to restart Access for it to work again.

I'm wondering whether this has anything to do with Exchange, Outlook or Win2k?

David

 

[Basia]

I am having the same problem. Do you ever figure out why you had to leave the session to send the next email batch?

Thanks..Basia