Merge List Box rows to text box

[Hasse]

Hi,

In my InfoPath form I have a List Box with several rows of data collected
from a SharePoint list.
If I would like to use vb script to merge all the rows so it will look
something like this: row1data;row2data;row3data;..... and put it in a Text
Box how can I accomplish that?

Any assistance would be highly appreciated,
Hans

 

[Hasse]

Hi,

Thanks for trying to help me with this but after looking around in the
newsgroup I have to admit that I have not become any wiser.
Can you please explain this a little bit more and maybe provide me with some
code?
And yes, my List Box is being populated by a secondary data source,
SharePoint Contacts List.

Regards,
Hans

 

[S.Y.M. Wong-A-Ton]

The steps I outlined are the steps you need to take; I cannot explain more
unless you have a more specific question. I'm very tight on time these days,
so give me a couple of days and I might be able to put together a solution
for you and post it on my website by next week.

 

[Hasse]

Hi,

I can wait until next week if you can provide me with a solution.
To help you do this I shall try to explain what I wan't to do.
In SharePoint I have a Contacts List with columns for E-mail address and
Group.
In my InfoPath form I get the E-mail address from all contacts that belongs
to the groups Market and Coordinator in to a List Box. Wen clicking on a Send
Mail button
I wan't to, using VB-script, merge the E-mail addresses in my List Box and
put them in the To field in my mail, like,
(e-mail address removed);[email protected];[email protected].
Hope this is enough for you to solve this problem of mine.

Regards,
Hans

 

[S.Y.M. Wong-A-Ton]

If you are looking to merge email addresses, you can also do it without code
using the method described in this article:
http://blogs.msdn.com/infopath/archive/2006/04/05/569338.aspx

 

[S.Y.M. Wong-A-Ton]

Part of the solution to your scenario is given here:
http://enterprise-solutions.swits.net/infopath/generate-string-email-addresses-list-vbscript.htm

The other part should be pretty straightforward to produce now: For the
group you need to add an XPath filter when retrieving the contact rows. And
to fill the "To" field it is best to just set the "To" field's value equal to
the value of the "emailAddresses" field using a formula.

 

[Hasse]

Hi,

Thanks a lot for your solution.
Now it works perfect.

Regards,
Hans