Send me email with info on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created quite a successful Contacts database that now includes 500+
names. In order to keep it as up-to-date as possible, I am creating a form
that all the various Department heads can use to inform me of changes... new
employees, people who've left and other such amendments.

Is there a way I can, upon clicking a 'submit' button, have an email
automatically sent to me with all the info from the various text boxes?

Can it be sent automatically or will it just pass the info to a new email
message and the user also needs to click 'Send' from Outlook too?

Thanks
 
One alternative to investigate is the DoCmd.SendObject method. It allows
you to send a form using the acSendForm parameter. I do not know what
controls you have on your form and whether all the control values will be
captured, however, you may want to try this alternative. For example:

DoCmd.SendObject acSendForm, "Form3", acFormatRTF, "(e-mail address removed)", , ,
"Test Email", "Some text.", False

If you cannot capture all the form control values, you could use the
acSendNoObject parameter and build a text string with the values of the
various form controls and then use the string as the value of the
MessageText parameter.

Your users may encounter the Outlook security warning when the email is
sent. I believe there are ways around this, if you choose. The following
link has some additional information.

http://www.outlookcode.com/d/sec.htm#sendkeys

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have created quite a successful Contacts database that now includes 500+
names. In order to keep it as up-to-date as possible, I am creating a form
that all the various Department heads can use to inform me of changes... new
employees, people who've left and other such amendments.

Is there a way I can, upon clicking a 'submit' button, have an email
automatically sent to me with all the info from the various text boxes?

Can it be sent automatically or will it just pass the info to a new email
message and the user also needs to click 'Send' from Outlook too?

Thanks
 
Why not give them the ability to update a record themselves and just
document the change?
 
Oops! Misread the post. Why do you need to know that Contact information
has changed? It sounds as if you want to be notifying when the change
has been made. Correct? If so, then just add a field dteLastModified and
capture the date and time when the record is updated. Then create a
continuous form that displays records sorted by the dteLastModified
field in Descending order. This will put the most recently changed
records at top. If you apply conditional formatting, you can alter the
records to highlight those modified in the last 14 days or so if you desire.
 
Dave Lloyd.
Thanks, thats exactly what I needed (sendobject) however the answer about my
post regarding the syntax prompt only appearing for ½ a second allowed me to
'play' and work it out.

Dave Holley.
I can see where you are coming from in allowing others to update the
database however that is not possible in this particular situation. The
database (front end and back end) is read-only except to a small team who
will administrate it, because the contact list has 550+ people from 9
branches of our company.

And before you go on about it... i know, i know, i know. Its not the most
efficient set-up but its the best I can do given the set-up i have to work
with !!!

In any case, thanks for your input guys.
 
Back
Top