Does anybody know of a way inwhich I can EMAIL the record data from the form ?
I want to create a button whereby on click, the data on the form is automatically pasted into the body of a new email, obviously Outlook will already be open.
What I am after is the same principle as what the formmail script does, but with an access form instead of a HTML page.
Anybody got any ideas on this ??

Thanks,
-NEIL POPE

[This message has been edited by popen (edited 10-16-2000).]

What I think you need is the ...

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

On the press of the button gather all the information into a string and send it using thsi command. It will automatically create an Outlook mail object for you.

Hope this helps

Thanks for the info, it works fine !
Well, not quite fine, in that it writes every record onto the email, not just the record I have open at that time.
Any help on this one >?

Thanks,

-NLP