 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / September 2007Send instructional email to UserID requestor
Hi all.., I'm adding a UserID/password request item to my Request for Service form. The request catelog item involves a section with a repeating table and includes theses fields: (repeating table accomodates multiple names for those requesting id's and passwords to a web-based utility) Employee# EmployeeName EmployeeEmail Justification The requestor would press a 'Submit' button and the form will be sent to a SharePoint library where a provisioning person manages and fullfills the requests. Upon fullfillment of the request: (provisioning person will press a button entitled 'Close') My question/need is this..., I want to send out a separate email from Outlook (with instructional text) to those addresses in the EmployeeEmail field. Thanks so much in advance for your assistance. DennisO Hello You can set the Submit options in the Submit Button Properties Double click on the Submit Button -> Properties-> Submit Options Check Allow users to submit the form -> Select Email in the drop down Click Add and select Fx at the end of To Button and set the Employee Email Field here I hope this will help you  SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > Hi all.., > [quoted text clipped - 23 lines] > > DennisO Thanks Kalyan.., I apologize for not being clear..., however, you've gotten me a few steps closer nonetheless..., My issue involves a repeating table, so consequently the result of placing the email field in the 'Insert Formula' box would send a single email to the person listed on the first row. (Would you know of a way to capture all the email addresses should there be multiple rows in the repeating table ?) Additionally, my ultimate goal is to send the recipients an email with instructions on how and where to log in to our secure web site, and not simply turn the form around; (would you think that this might be better handle via vba or jscript code ? thanks again for your assistance. DennisO ---------------------- > Hello > [quoted text clipped - 33 lines] > > > > DennisO Have you already seen this article to concatenate email addresses from a repeating table? http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx --- S.Y.M. Wong-A-Ton > Thanks Kalyan.., > [quoted text clipped - 54 lines] > > > > > > DennisO Thank you sir. I get an error (The formula contains one or more errors") when I attempt to use the solution in this article. I attempt to add the recommended formula: (sub'ing my own fields in the appropriate places of course) eval(eval(person, "concat(my:email, ';')"), "..") to the "To" line on the data connection dialog and I recieve the error. Press the details button reveals: Unexpected character. eval(eval(my:EditSection/my:group3/my:User, "concat(my:my:EditSection/my:group3/my:User/my:UserEmail, "-->;<--")"), "..") Any thoughts on this one ? thanks in advance for your assistance. DennisO ---------------------------- > Have you already seen this article to concatenate email addresses from a > repeating table? http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx [quoted text clipped - 59 lines] > > > > > > > > DennisO Actually, it is miss. :) Pay special attention to the single and double quotes used in the expression. You are using double quotes everywhere now, which is causing the error. Try this: eval(eval(my:EditSection/my:group3/my:User,"concat(my:UserEmail, ';')"), "..") --- S.Y.M. Wong-A-Ton > Thank you sir. > [quoted text clipped - 84 lines] > > > > > > > > > > DennisO Works like a champ ! Thanks so much ! Ok.., the next part may be a bit more difficult. I want to take the list of email addresses from the repeating table and populate an Outlook email msg with standard boiler plate instructions. Will I have to do this programatically, and if so, how ? thanks in advance. D ------------------------- > Actually, it is miss. :) > [quoted text clipped - 96 lines] > > > > > > > > > > > > DennisO
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.