Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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