Sendobject

[Snurre]

Hi..

I use this code and it works great. However, it works only
once. To be a able to send a new mail I have to close and
open the Access databse.. How is ir possible to send e-
mail several times without restarting?

DoCmd.SendObject acSendQuery, "rwExcelrom", acFormatXLS, _
"(e-mail address removed)", , , "Subject", "Message", True


Regards
Snurre

 

[Ki Yi [MS]]

Hello,

Check out this article -

SendObject method fails in Access 2000 WGID:147
ID: 260819.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;EN-US;260819

You can also try following method instead:

How to use Automation to send a Microsoft Outlook message using Access
WGID:147
ID: 209948.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209948

Hope this helps!

Ki