Ok I have a fdf to pdf system in place that is pulling from my sql db for HR purposes. We are making some changes and one of the things they want is the ability that when someone submits a form it compiles the fdf/pdf and sends out a email with the pdf attached for the new department. I was curious if any of you had any ideas. Here is the script I have that sends out an email notifying users that changes have been made along with at the bottom I even tried just making a button they could click that would compile the fdf and pdf but I get asp errors when trying to run it. Here is my script if it will post here.. I have come to the conclusion that the button to compile in the email will never work due to the fact it doesnt know what user info to pull to bring the pdf up. If you guys got any ideas as to have it auto compile and send a email attachment at time of form submission I am all ears.
ObjSendMail.To = ISRTUsers
‘ObjSendMail.To = “webmaster@archbold.org”
ObjSendMail.Subject = “ISRT – Delete Account Request – Effective ” & Request.form(“month2”)+1 & “/” & Request.Form(“day4”) & “/” & Request.Form(“year1”) & “.”
ObjSendMail.From = “webmaster@archbold.org”
ObjSendMail.HTMLBody = “Archbold Medical Center” & “
” & “Information Systems Record Tracking System (ISRT)” & “
” & “Effective Access Termination Date: ” & Request.form(“month2”)+1 & “/” & Request.Form(“day4”) & “/” & Request.Form(“year1”) & “
” & “
” & Request.form(“SFN”) & ” ” & Request.form(“SLN”) & “ has submitted a Delete Account request for:
” & “Employee Name: ” & Request.form(“empFirstName”) & ” ” & Request.form(“empMI”) & ” ” & Request.form(“empLastName”) & “
Employee Number: ” & Request.Form(“empID”) & “.” & “
” & “Facility: ” & facility & “
” & “Department: ” & Request.form(“department”) & “
” & “Job Title: ” & jobTitleName & “
” & Response.Write “
“