Email report with data attached

[Guest]

I have a database where I keep track of student employees. The database has
three forms, a new hire form, a supervisor form and a financial aid form.
The student fills out a new hire form that requires additional input from the
hiring department and from financial aid. Included on the new hire form is
the name of the supervisor. I have a table that contains the supervisor name
as well as email address. Once the student has filled out the new hire form,
I would like to generate an email that sends a report, identifying the new
hire, to the supervisor requesting them to fill in the missing information in
the database. I want the email to be generated automatically once the
student has completed the form selecting who to email to etc form the student
input or have the student pick the supervisor from a list to send the email
to. I ahve very limited knowledge of programming. Thanks.

 

[Guest]

Dear Newbie:

I've been programming for nearly 3 decades and am still struggling with
the problem of auto-generating (spawning) emails. I've done a lot of
homework in Excel on this problem and have learned that (a) you have to
understand how mail providers work, (b) how to interface your programming
code to that provider, (c) how to activate and then deal with mail sessions,
and (d) probably other stuff that I haven't figured out yet. Since you
posted this on 11/29/04 and haven't received a response yet, you might want
to repost it to see if anyone else has any ideas.

Steve in Ohio