VB Type Mismatch issues - inArray()

Answer 1

This exact code works elsewhere? Are you sure you're passing the arguments to the inArray() function in the right order? A string array and a string passed in the wrong order would cause a Type Mismatch error.

Answer 2

There is no built in function called InArray() in vbscript. Do you have the function included?

Answer 3

How about something like this instead:

strOut = ""
strIn = strEmail

strTmp = ""
For Each f In rs2.fields
    If Instr(strIn, "$*%%" & f.name) > 0 Then
        strIn = Replace(strIn, "$*%%" & f.name, rs2(f.Name).Value)
    End If
Next

strOut = strIn