densma
|
Posted: 02/29/2004, 7:25 PM |
|
i have a data entry form that include
txtfield for 'Firstname'
txtfield for 'Lastname'
a Radio button..option of 'Open' and 'Closed' -defualt option is open.
i want to create email function to send email using firstname.lastname field @domain.com when ever there the radio button changed to closed. i mean when ever radio button is change or updated to closed. this should trigger a send email. this update will be through grid report using update button.
i really need help to set this up. The form does not enclude email addr so i have to generate email usingfirstname.lastname@samedomain.com with custom msg on closed.selected on tha radio button.
thanks
|
|
|
Nicole
Posts: 586
|
Posted: 03/03/2004, 7:13 AM |
|
Hello,
Assign CCS Send Mail action to lets say Before Execute Update event (you can also use After execute Update). In generated code modify TO parameter to use control values:
.To = form_name.DataSource.Firstname.Value & "." & form_name.DataSource.Lastname.Value & "@domain.com"
_________________
Regards,
Nicole |
|
|
densma
|
Posted: 03/03/2004, 8:17 AM |
|
thanks..
will give it a try
|
|
|
|