Newbie Questions

Re: Email Popup when you submit a form via email

nukkumatti — Wed, 18 Apr 2007 07:10:59 GMT

Hi all,

this is more a question as a statement but wouldn't it be much easier to just use managed code (c#) and use a MailMessage object instead of a MailEnvenlope to send the notification. As far as I know you could achive exactly what you want ?!?

Re: Email Popup when you submit a form via email

Ted Fitch — Tue, 17 Apr 2007 23:05:16 GMT

Hi guys,

I am working on a project for a client right now where this is a requirement. We are in the process of getting this configured. We have done this before for a couple of clients.

The basic procedure is to use triggers on tables in SQL. You set up the trigger in SQL to send email. The trigger activates on INSERT, UPDATE etc. So when an InfoPath form is submitted to SQL the trigger is called and code is run that sends the email. You need to have SMTP access for the server, although you don't have to have SMTP configured on the server where SQL is.

Here is a link you can read more about triggers:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=59&rl=1

Re: Email Popup when you submit a form via email

Suzanne — Mon, 16 Apr 2007 19:52:32 GMT

I'd be interested in this workaround. Could you give me more information? I have a few developers who could help me with this if I need it.

Thanks!

Re: Email Popup when you submit a form via email

Greg Collins — Mon, 16 Apr 2007 17:17:23 GMT

Ted, do you have a quick sample of how this works? Just some stub code, etc?

Re: Email Popup when you submit a form via email

Ted Fitch — Sat, 14 Apr 2007 21:04:11 GMT

Hi Suzanne,

As Greg said, for security reasons this is not allowed in InfoPath. However, if you are really ambitious there are always workarounds :-)

I recognize this might be something that is totally not possible for you or soemthing that you even want to attempt, BUT one alternative to this would be if you were submitting the form data to SQL. Within SQL you can setup access to SMTP servers and autogenerate emails based upon conditions you setup in SQL. These would be totally independent events from InfoPath but it is possible to drive an entire email notification system outside of InfoPath and thus elimniate those popup boxes.

Re: Email Popup when you submit a form via email

Greg Collins — Thu, 12 Apr 2007 17:54:32 GMT

No problem.

Re: Email Popup when you submit a form via email

Suzanne — Thu, 12 Apr 2007 17:52:54 GMT

That's what I figured.

Thanks so much for getting back to me.

Re: Email Popup when you submit a form via email

Greg Collins — Thu, 12 Apr 2007 17:48:02 GMT

Welcome!

That's the Hundred Million Dollar Question that every asks. The answer is no. It is there for security reasons to prevent SPAM and other unintentional malicious use of a person's email address.

Email Popup when you submit a form via email

Suzanne — Thu, 12 Apr 2007 15:55:17 GMT

I have created a form with 3 submit buttons - one when you submit a request, one when the request is approved and one when the request is completed. I put rules in that will send an email to the appropriate person. However, my boss doesn't like the email form that pops up when you click the button. Is there some way to keep that box from popping up?

Thanks!