Getting value to email

[cmxulb]

Hello!,
How can I get the value to populate into an email of row 1?. I can get row 2, 3 and so on, but since row 1 it Dynamic Serial number. If I copy "=Row() -1" into .Htmlbdoy it wont work. THanks

 

[6StringJazzer]

Since ROW() will be equal to the variable iRow when this code executes, you can use iRow - 1 as the value in the Htmlbody. No idea where you want to put it, though.

 

[cmxulb]

Since ROW() will be equal to the variable iRow when this code executes, you can use iRow - 1 as the value in the Htmlbody. No idea where you want to put it, though.

Thanks! it works