email button

[anonymous]

I am using Access 2000. I have a account table named
tblAccount. I have an email address field within
tblAccount called . I open a form frmInvoice in
preview mode. I would like to have a button on the form
which if clicked would send the invoice to the email
address in tblAccount field [email]. If anyone knows a
fairly simple way of doing this please help. Thanks

 

[Joe Voll]

I am using Access 2000. I have a account table named
tblAccount. I have an email address field within
tblAccount called . I open a form frmInvoice in
preview mode. I would like to have a button on the form
which if clicked would send the invoice to the email
address in tblAccount field [email]. If anyone knows a
fairly simple way of doing this please help. Thanks[/QUOTE]

you can call the default mapi-compliant mailer (e.g. outlook or exchange)
with the
docmd.sendobject
method. this might be the easiest way to provide email functionality in you
access database.

if there is no mapi-compliant mailer installed on your system or the system
the database runs at you can use CDO or some other (third party) email
component.

Joe.