DoCmd.SendObject Fails

[Jonathan Wood]

I'm running Access 2007--I believe (the Help|About command has been pulled).

I have some VB code behind a form that was written many years ago and the
following line fails with some vague message about Access was unable to send
the email

DoCmd.SendObject acSendNoObject, , acFormatTXT, rsClients("Email"), ,
"<myemail>", "<mysubject>", sEmail, False

(Data enclosed in <> is replaced to hide real data. sEmail contains the body
of my email message.)

The only thing that I know of that has change since this code last worked is
that I've installed Windows 7 over my existing Vista installation

Is this a known issue?

Thanks.

Jonathan

 

[Douglas J. Steele]

Do you have a default e-mail client defined?

 

[Jonathan Wood]

Do you have a default e-mail client defined?

I'm not clear on exactly what determines if I do or not, but I'm assuming I
do. I use Windows Live Mail.

 

[Douglas J. Steele]

I believe how you do it varies from OS to OS. Check
http://www.freeemailtutorials.com/w...ettings/setAsDefaultEmailProgramOnWindows.htm

 

[Jonathan Wood]

According to Windows Live Mail, it is both the default email and newsgroup
handler, as I pretty much assumed it was.