InfoPath Dev

Yes, they are all on the same domain.  No, the form is not making any data connections to somewhere outside of the form's domain location

InfoPath integration with Outlook is limited at best especially when it comes to calendars.  I wouldn't recommend InfoPath for this solution.

You'll need to create a repeating control (table or section) that is bound to the secondary data connection.  Then inside the repeating control you can create a calculated value control whose value is the concat of those 2 fields that you mentioned.  That should allow the data to repeat rather than only give you the first row. Eval ...

AFAIK, the only way to do this through the UI is through that contextual menu that you were describing.  This is good usability feedback for MS that you should mention to them :)

If you want to get a specific row of repeating data you'll need to specify the row number in your xpath.  Something like: /my:myFields/my:CommoditySummary/my:Line_Items/my:Commodity/my:Origination[current()].  The index should be on whatever node is repeating, so that may be the commodity group in your case.  This is for the ...

Are the users on the same domain as where the form is located?  Is the form making any data connections to somewhere outside of the form's domain location?

 You would need two rules with opposite conditions in the checkbox, I think. One rule for "checkbox is true" and one rule for "Checkbox is false". Can you try that?

But in that scenario, wouldn't FirstName need to be unique for the method to return only one email address?

In the taskpane, click on myFields and select Add. You can add a node, which is not in the canvas.

Just verified, It's not the row index doing it. Ideas?