vb scrip to display name

[mightyqlikers]

Dear Qlikers,

i have two fields namely empcode and empname in app

i am looping through empcodes to send mail.

in mail body i want to display empname with repspect to empcode in mail.

kindly suggets.

Regards

$@M

[marcus_sommer]

If you have dependencies between different fields-values it's often easier to loop through a tablebox instead of reading and synchronizing values from several fields. See here a simple example and more could you find within the APIGuide.qvw in your install-folder:

set table = ActiveDocument.GetSheetObject( "TB01" )

w = table.GetColumnCount

h = table.GetRowCount

set CellMatrix = table.GetCells2(0,0,w,h)

for RowIter=0 to h-1

    for ColIter=0 to w-1

        msgbox(CellMatrix(RowIter)(ColIter).Text)

    next

next

- Marcus

[mightyqlikers]

hi marcus,

thanks for u r reply ,

but i have got in different way.

like

currently i am looping through empcode right

for single empcode there will be only one empname

so i have created one variable to find  empname and used that in vbscript.

Regards

$@M