Can't open the mail session

N

news.microsoft.com

Hi,
I have problem sending mail from Access.
I use Office2000, WinXP, mailprogram MS Outlook.
When I send the mail using the sub below I get this:
"Check your mail application to make sure that it's working properly."
and
"MS Access can't open the mail session"
In Files/Send to I can only send as attachment
What is wrong ? In Excel, Word no problem
//Janne

Dim MessText
MessText = "Blablaaaaaaaaaaaaaaaaaaaa " & _
Me.Avisering.Column(1, OID) & " mera blaaaaaaaaaa " & _
Me.Avisering.Column(2, OID) & "." & vbCrLf & _
"Mera blablaaaaaaaaaaaaaaaaaaaaa." & vbCrLf & _
"Med vänlig hälsning " & vbCrLf & _
"Knycker & Säljer" & vbCrLf & _
"Kalle Kluring"

DoCmd.SendObject _
objecttype:=acSendNoObject, _
To:=Me.Avisering.Column(8, OID), _
Subject:="Besiktning", _
MessageText:=MessText, _
EditMessage:=False
 
Top