How do you e-mail the contents of a form upon completion.

set up a button on the form and enter the following code on click or on doubleclick DoCmd.SendObject , , , , "", "", "", [fieldname] & [fieldname] etc. Hope this helps
http://www.access-programmers.co.uk/ubb/smile.gif

[This message has been edited by Dobie (edited 02-04-2002).]

The Docmd.Sendobject is great but it keeps telling me to log on to Hotmail. I use Yahoo. How can I change this?

John

It will send from your default e-mail account set up in Outlook (or whatever). If you wish to automatically send from another account, make this one your default.

Any idea how to do this with a report (email a report)?

I have a form setup with a list of report. At the moment there are command buttons for viewing the report and printing the report. I want to add one for emailing the report, so the user simply clicks the button on the form and their email program opens up ready to go. Is this poss?

Thanks in advance,

Scott.

Right

Download this database

ftp://216.122.167.138/pub/candace/candace/email/email.zip –

It can E-Mail multiple recipients and also forms etc.

It is a table and form on the form there are drop down boxes which let you select either a report, query, table or a form and then another which lists all your e-mail contacts, to, cc boxes. The email can be sent striaght from the form without opening outlook.

Its really amazing better that outlook me thinks

[This message has been edited by DocManDobie (edited 03-01-2002).]