HELP! Run Time Error '1004' for sending email via vba in excel

Hi,

I am trying to run the code below and I'm getting a run time error on this line. What I'm trying to do with this line is to send a row in the body of the email based on the index value i.

Please Login or Register  to view this content.

below is the complete code

Please Login or Register  to view this content.

the RangetoHTML function code is below

Please Login or Register  to view this content.

What is the value for r or are you referring to column R

Please Login or Register  to view this content.

This does not make sense - what are you referring to - column R??? If r is a variable it has not been declared or initialised

You are still trying to set a range with a value that not even been declared? If you want row index i and columns 1 to 15 then use

Please Login or Register  to view this content.

The problem is that you cannot set the range until you have a value for i so either declare the value and initialise it earlier or place the range statement inside the loop.