I have adapted Ron De Druin's Mail code for filtering each row and sending the mail.

I have 3 challenges

* i have to send the mail on behalf of somebody else, so i need to change the "From" field, how would I change it in the code
* One part of the subject is static for eg " Hi", the second part is the variable , this would be the field or cell for which Ron's code is filtering for that row and pasting the code int he HTML body.
* the filtered row gets pasted on the top of the HTML body, can I move it downwards or where I want?

So I would need Hi XXX for the first mail, Hi YYY for the second mail and so on and so forth where XXX & YYY are the filtering cell or unique value. How would i adapt that in the code?

Any help is greatly appreciated. Thanks in advance