Send instructional email to UserID requestor

[Denniso6]

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

 

[Kalyan G Reddy MVP (GGK Tech)]

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

 

[Denniso6]

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


----------------------

 

[S.Y.M. Wong-A-Ton]

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

 

[Denniso6]

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

----------------------------

 

[S.Y.M. Wong-A-Ton]

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, ';')"), "..")

 

[Denniso6]

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

-------------------------