[AccessD] sending an email via vba

Virginia;
Object would be a form, module, query, report, or table. Basically it would
attach the chosen object to the email. If you state acSendNoObject there
wouldn't be an attachment (hence, I suppose, why this is the default
option.)

HTH
John B.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> Hollis,Virginia
> Sent: Wednesday, November 05, 2003 10:17 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] sending an email via vba
>
>
> What does it mean by not sending object? I am confused, what is the email
> sending?
>
> DoCmd.SendObject acSendNoObject,
>
> Virginia
>
> -----Original Message-----
> From: John Bartow [mailto:john at winhaven.net]
> Sent: Wednesday, November 05, 2003 9:41 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] sending an email via vba
>
>
> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>