Email from access form

[robert]

Now I'm new to this, I'm trying to figure out how to email information
from an access 2000 table or query, and I find this site:
http://www.databasedev.co.uk/email-from-ms-access-form.html with a
great description of how to do it, only problem is that it's
personalized to email from this multi table 3 relationship system,
which is very aggrivating. I figure the easiest way to learn how to do
this is to create a table with 2-3 fields: name, email, comments, then
start testing the VB script to figure out how it works....Enter the VB
script and build from there, this guys table is too complex (not that I
dont understand relationships) but its too complex for me to use as a
basis for trying to figure out how to get this to work. Does anyone
know of a more simplified example of sending an emial from an access
form?

Thanks,
Robert

 

[Jeff L]

Try looking up SendObject in help. It tells you how to prepare an
email message from access. I have created a program that uses
SendObject to email individuals to inform them of what documents they
are missing for employment purposes. It works quite nicely.