[AccessD] sending an email via vba

John Bartow john at winhaven.net
Wed Nov 5 09:41:21 CST 2003


Oleg:
It would appear from your code that you are not sending an object
(acSendNoObject) which is the default for the SendObject method.

However EditMessage is boolean so IIRC it should read EditMessage:=False

HTH
John B.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> 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