automatic email

[Chris]

i have a form that i have shop floor employees using to fill out quality
defects that are found during operations. The form is called a QAR. Each
time an employee opens a blank QAR form for a new entry it automatically
populates the QAR number with the next sequential QAR number. This way
people in other functional areas can look up a QAR by a specific number.

Shop floor employees don't always want to follow directions when they fill
out a QAR because they would rather just stay busy doing their job. The last
step in their process is to send an email out to the reponsible party. I
already have an email "button" on the form, but they still forget to use it.
So, I need to come up with a way that when they select the responsible party
from a drop down menu field on the form, prior to closing out of the form, an
email message is automatically generated with the responsible party's email
address from that field already in the "Send To" field of the email. This
way they have to acknowledge it before they can close out of the form. This
will ensure that an email gets sent to the responsible party.

Does anyone know how to do this?

 

[Al Campagna]

Chris,
Sounds like you could use the same code that emails from the button, but
placed in the combobox's AfterUpdate event. Do a Refresh just before
doing the send...
Or... you could ask the user if the "Send To" value is good... with just
a
Yes/No message box... and the do the send.
Tweak to suit...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Klatuu]

I don't know if using the control to send the email is a good idea. If the
user doesn't have all the data in the form and sends the email, it could
fail or send incomplete data. Maybe the Form After Update event might be a
better choice?

 

[Al Campagna]

Hi Klatuu,
The OP indicated that, by the time the combo is filled in, the email
is ready to go. So, for a preliminary response, I chose not deal with
that issue.

I did suggest a user message to confirm the send, or not, but left that
to the OP...
I wrote...--
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[S.Clark]

Put code in the Form's AfterUpdate event to send an email to the responsible
party.

 

[Chris]

What kind of code. I have very limited code writing ability. Will this code
go out and find the person's email address so that it automatically appears
in the "send to" field of the email when the email opens?

 

[florine]

I don't know if using the control to send the email is a good idea. If the
user doesn't have all the data in the form and sends the email, it could
fail or send incomplete data. Maybe the Form After Update event might be a
better choice?

 

[florine]

I don't know if using the control to send the email is a good idea. If the
user doesn't have all the data in the form and sends the email, it could
fail or send incomplete data. Maybe the Form After Update event might be a
better choice?