aquire multiple email recipients depending on formular input

[Dennis Dürrenberger]

Hi,

I got a problem, as followed.
I implemented repeating dropdowns into a formular, that get their
information from an access database. Now I would like so send an email to the
recipients, selected by the dropdowns, all at one time, by only clicking one
button.
The email adresses are stored within the database connected to their names.

Now the question is, what formula do I have to put into the "To:" field, to
realize that idea.

In general: how can I read out data from a database, according to
information, that has been selected by the user in the infopath formular
(i.e. setting a pointer to a value in relationship to an input).

To make clear what I want:
Database:
Name: infopath
E-mail: (e-mail address removed)

Dropdown:
infopath

now I need some formula or code, that does this (on click):
lookup "infopath"@database
search for the row "email-adresses"
insert the email-adress related to "infopath" into the "To:" field


That should be some dynamic variable, because I need to send a bunch of
emails at one time to different recipients by only clicking one button.

I hope you can help me.

Greets,
Dennis

 

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

For your drop-downs, use the name (infopath) as the display name and the
email ([email protected]) as the value for each drop-down. Then use this neat
trick from the InfoPath Team
http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx to get the
email addresses into the "To" field.

 

[Dennis Dürrenberger]

well, thanks a lot, that was just what i was looking for

only thing is... "'eval' is not a valid XSLT or XPath function"
is this function only implemented in SP2 ? Because atm i only got SP1
But should be no problem, to upgrade, if this should really be the reason,
why it does not work.

But while im already posting here...
Another problem just came up. Is is possible, that the sent form is not an
attachment, but the mail itself.
Or even better: the form would not be sent at all.

I mean like:
Fill in the form to specify your needs (i.e. datainput);
Send the form, by one click to the selected recipients;
The recipients get a "plain" email, including the information that was
filled in by the mail-sender;
No attachment, no further filling in by the recipient. Just information
transfer.

thx & greets
Dennis

 

[Dennis Dürrenberger]

okay i found out how not to apply the default attachment to my sent emails
sometimes, the most obvious is not so obvious, at all...
just erased the "attachment name" field in the options of the data
connection, and that´s it... no more attachment.

but I still got the problem with the eval() function...

 

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

Is that the error you're getting? 'eval' is not a valid XSLT or XPath
function? I'm not sure if it's service pack specific, but you could try
upgrading...

What is the current expression you're using?

 

[Dennis Dürrenberger]

okay it is not SP specific.
yes der error message is: 'eval' is not a valid XSLT or XPath

function

the current expression I added to the data connection is:
eval(eval(person, "concat(my:email, ';')"), "..")
just like described in the linke you posted earlier.
while "person" is the database connection
and "my:email" is the row-name of the databases email entrys

still not working

 

[Dennis Dürrenberger]

xdMath:Eval instead of just "eval"
solved the problem.

thx for your help, now i got what i needed.

 

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

Great! And you're welcome!