Newbie Questions

Re: Select fields in Body of Outlook Email (2003)

ZaiZai — Tue, 23 Dec 2008 12:17:09 GMT

Was wondering how you solved the adding fields values into an InfoPath email data connection that you posted back in January. You say that you solved it, but no resolution was added.

I would like to do something very simililar if possible in InfoPath 2003 and Outlook.

Thanks.

Re: Select fields in Body of Outlook Email (2003)

ScottD — Wed, 09 Jan 2008 20:51:07 GMT

I have solved this issue - Thanks for your support / help

Re: Select fields in Body of Outlook Email (2003)

ScottD — Wed, 09 Jan 2008 19:49:38 GMT

I am still having issues trying to get this to work:

I still need to submit data into the intro (body of email) in infopath 2003 -

I am using the code.

var mail = XDocument.DataAdapters("Submit");

var NTID = XDocument.DOM.selectSingleNode("//my:myFields/my:group1/my:txtUserNTID.text"); var CPU = XDocument.DOM.selectSingleNode("//my:myFields/my:group1/my:txtComputerName.text"); mail.Intro = CPU
Submit();

None of this is working correctly - any comments?

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 21:35:36 GMT

Adding More in what i have done:

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of arguments.
//=======
function CTRL136_5::OnClick(eventObj)
{

var mail = XDocument.DataAdapters("TEST-NOCC");
var oOSOA = XDocument.DOM.selectSingleNode("/myFields/secProcessorInfo/fldOSOA.text");
var oLocation = XDocument.DOM.selectSingleNode("/myFields/secProcessorInfo/fldLocation.text");
var otestme= 31223
mail.Intro = oLocation
mail.Submit();

when i make mail.Intro = otest me it works fine
using the oLocation or oOSOA

I get type mismatch

I still can not figure out what I have done wrong

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 19:42:33 GMT

I am still confused on this, from what i have seen every example is:

Xdocument.DOM.SelectSingleNode("my:myfields/my:comments"))

I amnot using the my: as it gives me an error it is undefined. but I do not know what to define it as.

Could that be my issue?

The way my form is set up now is i have a section and the fields inside of this.

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 19:05:31 GMT

I have tried the above OSOA.text and i get "object required"

But I do apprecaite your help so far.

Re: Select fields in Body of Outlook Email (2003)

Clay Fox — Fri, 21 Dec 2007 18:52:52 GMT

OK, paying more attention now.

Try

Mail.Into = OSOA.text

Your assignments are to the fields not the values.

Also could add .text when you assign the variable so it it a text value.

Look at some other code example at how to reference field values in code.

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 18:45:07 GMT

Seems I am still having zero luck.

using code:

var mail = XDocument.DataAdapters("TEST-NOCC");
var OSOA = XDocument.DOM.selectSingleNode("//myFields/secProcessorInfo/fldOSOA");
var Location = XDocument.DOM.selectSingleNode("//myFields/secProcessorInfo/fldLocation");
mail.Intro = "MY TEXT HERE"
mail.Submit();

}

I get the "MY TEXT HERE" In the Body of the email

Now if i try:

Mail.Intro = OSOA

I get a type mismatch error on that line

Of i try:

mail.Intro = concat(OSOA);

I get Object expected

What am I doing wrong?

Eventually I will need Body to have:

Location: LocationA (or what is in the Location text box)
OSOA: (whatever is in the OSOA text box)

i will need about a dozen more fields, but if i can get two working, rest should be easy.

Re: Select fields in Body of Outlook Email (2003)

Clay Fox — Fri, 21 Dec 2007 18:03:34 GMT

I would insert a line for a MSGBOX(oOSOA) or Alert() etc after each line to verify you are getting the field values and the concatenated value is correct. Can't remember which command does a pop up message in VBS but at least then you can see what is transpiring. Is & the right choice for concatenation?

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 17:27:25 GMT

When I use this code I get 0 in the Intro:

var mail = XDocument.DataAdapters("TEST-NOCC");
var oOSOA = XDocument.DOM.selectSingleNode("//myFields/secProcessorInfo/fldOSOA");
var oLocation = XDocument.DOM.selectSingleNode("//myFields/secProcessorInfo/fldLocation");
mail.Intro = (oOSOA & oLocation);
mail.Submit();

however if I do

mail.Intro=("TEST"); i do get test to come up

Re: Select fields in Body of Outlook Email (2003)

Clay Fox — Fri, 21 Dec 2007 16:52:20 GMT

http://www.infopathdev.com/forums/p/3645/12813.aspx#12813

http://www.infopathdev.com/forums/p/3782/14800.aspx#14800

Here are some related posts to get you started.

Re: Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 16:36:49 GMT

I appreciate it but seems I can not find anything that has worked so far!

I am not sure what I am doing wrong..

Re: Select fields in Body of Outlook Email (2003)

Clay Fox — Fri, 21 Dec 2007 15:55:49 GMT

Welcome to the forum Scott.

I am pretty sure, that with code, you could customize the Intro of the email to include your fields. mail.Intro but you should be able to search on the site here for posts on email and code.

Select fields in Body of Outlook Email (2003)

ScottD — Fri, 21 Dec 2007 15:00:38 GMT

I am using Office 2003 and in an infopath form when they submit the form, i still need the attachment to be sent,

However, I need a way to pull certain fields from it and put into body of emai, prefer plain text

For example:

Name:
Address:
Phone:
Customer #:

I would like to have the above text bolded - But i am new to jscript and cant figure it out!
and searched this and usenet with out finding anything that works!

Aprreciate the help[ and time!