Submitting through Email - Customised Formula

[Mohammed Zenuwah]

Hi There,

I'm hoping someone can help me with a small problem I'm having.

I've created a form which submit data within the form to a sharepoint
libary, as well as this I want the form to submit to a user via email. I've
created a rule which will first submit to the sharepoint server and then
perform the "sumbit by email" function.

Within the "submit by email" I would like to submit the form to a specific
email address based on the value within one of the fields.

The field in question would be the country field. Say for example the form
was submited with country "Spain" i would like a formula which would email
specifically to say "(e-mail address removed)" and if the country was "Ireland" it would
email to "(e-mail address removed)".

Is this possible using the formula section, within the send by email function?

Thanks in advance,

Mo..

 

[dyo]

Hi There,

I'm hoping someone can help me with a small problem I'm having.

I've created a form which submit data within the form to a sharepoint
libary, as well as this I want the form to submit to a user via email. I've
created a rule which will first submit to the sharepoint server and then
perform the "sumbit by email" function.

Within the "submit by email" I would like to submit the form to a specific
email address based on the value within one of the fields.

The field in question would be the country field. Say for example the form
was submited with country "Spain" i would like a formula which would email
specifically to say "(e-mail address removed)" and if the country was "Ireland" it would
email to "(e-mail address removed)".

Is this possible using the formula section, within the send by email function?

Thanks in advance,

Mo..

 

[Deanna]

I am trying to do the same thing. Did you have any luck. I am very new to
SharePoint and I do not know anything about programming if any is required.

 

[Mohammed Zenuwah]

Hi Greg,

Thanks loads for the repsonse, both solutions seem viable.

I'm going to start with options 1. I don't suppose you can give me more
detail on how this would work.

I'm assuming I would create a hidden field, how would I add all the required
email address to this field and then link them to the country field?

thanks in advance,

Mo...

 

[Mohammed Zenuwah]

Hi Greg,

Again you've been a valuable resources, I believe I'm 50% of the way there
now.

I've created a xml document in notepad using the code template below, and
I'm able to link this to the form as a secondary source however I'm not sure
how to link the fields in the secondary sources to that of the main source
and then provide the currect rule within the send mail option?

Mo...

To create the links, you will need a secondary data source... for example:

<EmailSubmit>
<EmailTo/>
<Countries>
<Country name="Spain" email="(e-mail address removed)"/>
<Country name="Ireland" email="(e-mail address removed)"/>
...etc...
</Countries>
</EmailSubmit>

Then when your drop-down value changes, you look up the Country name based on the new value selected in the drop-down list, get the email associated with that country, and place it into the EmailTo field.

Then your email data connection is set up to fill the TO field with the value of EmailTo.

Make sense?

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Hi Greg,

Thanks loads for the repsonse, both solutions seem viable.

I'm going to start with options 1. I don't suppose you can give me more
detail on how this would work.

I'm assuming I would create a hidden field, how would I add all the required
email address to this field and then link them to the country field?

thanks in advance,

Mo...

Two options:

1. Create a hidden field which holds the email address. This is updated when the country field changes. Use this field in your email data connection.

2. Perform your email submit via code instead of rules. Then you can set the TO value however you want.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Hi There,

I'm hoping someone can help me with a small problem I'm having.

I've created a form which submit data within the form to a sharepoint
libary, as well as this I want the form to submit to a user via email. I've
created a rule which will first submit to the sharepoint server and then
perform the "sumbit by email" function.

Within the "submit by email" I would like to submit the form to a specific
email address based on the value within one of the fields.

The field in question would be the country field. Say for example the form
was submited with country "Spain" i would like a formula which would email
specifically to say "(e-mail address removed)" and if the country was "Ireland" it would
email to "(e-mail address removed)".

Is this possible using the formula section, within the send by email function?

Thanks in advance,

Mo..