C
Chey
Hello
I have a checkbox on a form. When I close the form I
want this to happen for everyone that has a check box.
So I know I have to do this on the on close, but how do I intergrade the
checkbox into everything. Also, I tried to figure out myself what is wrong
with the code and I still can't figure it out.
DoCmd.SendObject acSendNoObject, , , To:=, Subject:=[TA Number],
MessageText:="Dear " & [First and Last Name] & ": " & vbcrlf & "Your travel
to " & [Destination] &
" on " & [Date Leave] & "has been approved.", EditMessage:=True
This is what I have, It all is red,
Email is where I have the persons email
TA Number is what I want Subject to read
First and Last Name is the Travelers name
Destination is where the are going
Date Leave is well date leave
and the I typed the rest of my message.
What did I do wrong?
Thanks for all your help.
Chey
I have a checkbox on a form. When I close the form I
want this to happen for everyone that has a check box.
So I know I have to do this on the on close, but how do I intergrade the
checkbox into everything. Also, I tried to figure out myself what is wrong
with the code and I still can't figure it out.
DoCmd.SendObject acSendNoObject, , , To:=, Subject:=[TA Number],
MessageText:="Dear " & [First and Last Name] & ": " & vbcrlf & "Your travel
to " & [Destination] &
" on " & [Date Leave] & "has been approved.", EditMessage:=True
This is what I have, It all is red,
Email is where I have the persons email
TA Number is what I want Subject to read
First and Last Name is the Travelers name
Destination is where the are going
Date Leave is well date leave
and the I typed the rest of my message.
What did I do wrong?
Thanks for all your help.
Chey