Newbie Questions

Re: Sending form data via smtp and Visual Basic .NET

pvinn — Tue, 07 Oct 2008 14:34:07 GMT

Thanks for the fast replies !!!

I was able to steal some of that code and make it do what I wanted

I'm finding there's not a lot of VB.NET examples out there, mostly Jscript

Here's what I took,

'get the value from the text field

Dimbody AsString= MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:Table_1/@Day_of_week", NamespaceManager).Value

'get the value from the date field

DimdateField AsString= MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:Table_1/@Date", NamespaceManager).Value

'set the information for the message

DimfromAddress AsMailAddress = NewMailAddress("healthcheck@test.com")

DimtoAddress AsMailAddress = NewMailAddress("pnaccarato@test.com")

Dimmsgmail AsMailMessage = NewMailMessage(fromAddress, toAddress)

'the body has the date variable we created in it, the subject uses the value from our text box -- mind you, this is all made up for a demo, so it isn't all that interesting

msgmail.Body = body

msgmail.Subject = "Health Check for " + dateField + ". Please review it."

Only 1 problem left, I have to pull about 70 other data fields from my form and place it into the email body with comments before each

Is there an easy way to do that ?? Or to even send all the data fields at once ? If I can't send all the data at once, I'll have to sit there and code 70 fields into my code

Ex: Body needs to look something like this

--------------------------------

"Date" - data from </dfs:myFields/dfs:dataFields/d:Table_1/@Date>

"Day of Week" - data from </dfs:myFields/dfs:dataFields/d:Table_1/@Day_of_week>

etc....

Re: Sending form data via smtp and Visual Basic .NET

sandhyapati — Tue, 07 Oct 2008 06:25:44 GMT

Hi,

Can you go through the below links

http://www.infopathdev.com/forums/t/2562.aspx

http://www.infopathdev.com/blogs/hilary/archive/2008/08/24/so-you-want-to-send-an-email.aspx

I hope they may help you.

Re: Sending form data via smtp and Visual Basic .NET

Anuma — Tue, 07 Oct 2008 06:22:04 GMT

Hi,

can you verify this link.

http://www.a1vbcode.com/snippet-3384.asp

Sending form data via smtp and Visual Basic .NET

pvinn — Tue, 07 Oct 2008 05:43:09 GMT

Hi, having a lot of trouble trying to develop code for VB.NET for what I need to do. I'm a real newbie to .NET but do have a lot of scripting background. I've been searching the web and the forums for about a week now, and have only came up with the following.

I need to send an email via smtp with my infopath form data, in either clear text or an embedded form format, (attachment will be my last resort)

Data gets sumitted to a SQL DB

How do I get my data into an snmp email ? Does anyone have any code that will do this ?

Dim client As New SmtpClient("server.test.com")
Dim toAddr As New MailAddress(user@test.com)
Dim fromAddr As New MailAddress("healthcheck@test.com")
Dim message As New MailMessage(fromAddr, toAddr)
Message.IsBodyHtml = True
Message.Subject = "This is a Test"
Message.Body = "<html><body><b>This is an </b> <font color=red>HTML Message</font></body></html> "