Newbie Questions

Re: Submit form as email, NOT email attachment

matjan — Mon, 02 Nov 2009 10:56:07 GMT

TXPoloPolo:

This thread was related to using JScript code to replicate the eMail function (albeit with more complex logic) instead of using the built in Submit to Email button property which works fine when there is no need for custom formatting of the message header or requirement of dynamic recipients based on form content.

-Marco

Hi everyone,

Is there anyone who could help me convert the JScript code to VBA?

Re: Submit form as email, NOT email attachment

TXPoloPolo — Wed, 08 Apr 2009 19:07:40 GMT

This thread was related to using JScript code to replicate the eMail function (albeit with more complex logic) instead of using the built in Submit to Email button property which works fine when there is no need for custom formatting of the message header or requirement of dynamic recipients based on form content.

-Marco

Re: Submit form as email, NOT email attachment

rojaPeram — Wed, 08 Apr 2009 17:45:48 GMT

I am working on infoPath 2007 and trying to send view via email in InfoPath 2007. Can you please tell how to do that ? Thanks in advance.

Re: Submit form as email, NOT email attachment

TXPoloPolo — Wed, 29 Oct 2008 23:23:47 GMT

Thank-you Albert and nukkumatti for the explanations that you both provided for the InfoPath 2003 workaround . I have been able to use the Application.ActiveWindow.MailEnvelope function to construct an email with the active view similar to the way that InfoPath 2007 acts. http://msdn.microsoft.com/en-us/library/aa167754(office.11).aspx

My question is: Can I send the form in "Read-Only Snapshot" just exactly like I can in Infopath 2007? As your example works now, the form's template remains as an attachment which would allow the form to be "Editable". Unfortunately, this has the side-effect of causing most recipients to have to click on on a security warning before they are allowed to read the message content. I'm also afraid that some companies might block messages that include the XML "code".

I was at a dead-end trying to get the EmailAdapter object http://msdn.microsoft.com/en-us/library/aa167746(office.11).aspx working properly for the non-Office 2007 users.

Thanks again for your help,

-Marco

Re: Submit form as email, NOT email attachment

CheapRound — Wed, 22 Oct 2008 12:59:26 GMT

Hi Ebonymb

I am very interested in how you got this to work. Where did you put the code and which bits needed changing

Any help greatly appreciated

Re: Submit form as email, NOT email attachment

ebonymb — Mon, 05 May 2008 02:20:49 GMT

Is it possible to link this line to datasources in the form? for the subject i'd like to add a concat expression and for to, i'd like to link it to another data field in the form.

OpenMailEnvelop("this is the subject", "someone@somewhere.com")

Re: Submit form as email, NOT email attachment

ebonymb — Fri, 04 Apr 2008 15:21:38 GMT

This worked! Thanks much!! I was even able to identify some errors in how I applied the code and resolve them. Thanks again!

Re: Submit form as email, NOT email attachment

Albert — Fri, 04 Apr 2008 13:37:01 GMT

Like nukkumatti said there is an option to send the current view in an email with InfoPath 2003 using code/mailenvelop.

Example jscript code:

function OpenMailEnvelop(subject, to)
{
    try
    {
  var oEnvelope = Application.ActiveWindow.MailEnvelope;

  oEnvelope.Subject = subject;
  oEnvelope.To = to;
  oEnvelope.Visible = true;

        return true;
    }
    catch(exception)
    {
        return false;
    }
}

function btnSomeButton::OnClick(eventObj)
{

OpenMailEnvelop("this is the subject", "someone@somewhere.com")

}

It actually opens a 'mailenvelop-bar', so it requires user interaction.

I don't have ip 2003 installed here, so i can't test.

Albert

Re: Submit form as email, NOT email attachment

Clay Fox — Thu, 03 Apr 2008 23:03:56 GMT

You can send the "view" via email in InfoPath 2007. However if they do not have InfoPath they will not be able to really view the form or update the data.

You can attach the XML but there is not much they can do with it in the raw state.

Another option is InfoPath form services so people without InfoPath can view the form in a browser.

Re: Submit form as email, NOT email attachment

ebonymb — Thu, 03 Apr 2008 22:52:36 GMT

I have a form already setup to to submit to a sharepoint library location and it works with no problem.

Within the form are check box options. I want to setup a submit option for one of the check boxes to email a plain text or embeded version of the form over outlook. This is necessary because the recipient doesn't have InfoPath viewing capabilities. The coding sounded like a good idea but it looks but i don't know it well enough to stumble my way through it.

Re: Submit form as email, NOT email attachment

Clay Fox — Thu, 03 Apr 2008 22:41:58 GMT

Hi and welcome to the forum.

You probably need to give me a bit more details.

What are you starting with and what do you want to end up with?

You want to fill out a web form and then submit it via email to others?

Do you need to store this data in a database? Do you need to pull dat from a database?

You can have InfoPath XML documents hosted in a browser with MOSS 2007.

You can email a link or an attachment (attachment does not do a lot of good if they have to open it in a browser)

You can also connect to external datasources or submit the forms to web services or web servers for storage or processing.

Re: Submit form as email, NOT email attachment

ebonymb — Thu, 03 Apr 2008 22:35:30 GMT

I know nothing about coding in Infopath. Is there a way I can create an HTML form submission and convert it to something Infopath can use? All I really want to do is submit the form fields either in plain text or embedded within outlook. With no coding skills, not sure how I can accomplish this.

Re: Submit form as email, NOT email attachment

bobspearing — Thu, 20 Dec 2007 17:34:49 GMT

Can this be used with Infopath 2003 ?

Looks neat - how do I achieve this?

Cheers

Bob

Re: Submit form as email, NOT email attachment

heath3106 — Mon, 01 Oct 2007 18:32:43 GMT

I'm a newbie at coding. Would this be entered in MSE under the OnSubmit button? Also, what needs to replace the underlined text below if my subject line is populated by a specific field on the form?

mail.Subject = "MY Subject Text";

Thanks.

Heath

Re: Submit form as email, NOT email attachment

nukkumatti — Thu, 12 Jul 2007 05:48:44 GMT

Hi, you can use this bit of code to send the form in the body of an email and not as an attachment. even user who havn't infopath installed can view it: var mail = Application.ActiveWindow.MailEnvelope; mail.Subject = "MY Subject Text"; mail.Visible = true;