[AccessD] sending an email via vba

rusty.hammond at cpiqpc.com rusty.hammond at cpiqpc.com
Wed Nov 5 09:36:01 CST 2003


Oleg, it should work just as you have it.  Since you specify acSendNoObject,
the e-mail gets sent with just the Subject and message you enter and doesn't
attach a file.

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Wednesday, November 05, 2003 9:06 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] sending an email via vba


Hi Group, I only know how to do this, when there is an object to be sent,
how to do this when there is no object ?


Function SendEmail()

DoCmd.SendObject acSendNoObject, _
To:="Oleg_123 at xuppa.com, _
Subject:="Database UpDates", _
MessageText:="There hasn't been any changes since last time", _
EditMessage:="No"

End Function


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list