[AccessD] sending an email via vba

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Wed Nov 5 14:37:59 CST 2003


thank you, now it works. (I was trying "no" and "false" in quotations)

> 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
>>
>>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



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




More information about the AccessD mailing list