how to replace @VARIABLE in text file with value of Emails in xml file

[johnfaj]

How i can read this xml file

<Subs>
<Sub Report="BusinessSummarySubs" EMails="lalla@yahoo.com; haha@yahoo.com">
<Sub Report="PlayerSubs" EMails="hehe@hotmail.com">
</Subs>

and replace @VARIABLE in BusinesSummarySubs.txt with EMails value in

Here is the content(part of the content) from BusinessSumarySubs.txt

CType(extensionParams(0),ParameterValue).Name = "TO"
CType(extensionParams(0),ParameterValue).Label = ""
CType(extensionParams(0),ParameterValue).Value = "@VARIABLE

 

[jkspeed]

The Sub elements are not properly terminated. It should be.

<Sub Report="BusinessSummarySubs" EMails="lalla@yahoo.com; haha@yahoo.com"[b]/[/b]>

Does the number of email addresses in the XML file correspond to the number of lines in the txt with the @VARIABLE string? Or do you want to concatenate all email addresses and simply replace the a single instance of the @VARIABLE?