Before you start the loop, you set the email content to the message and table headings.
However, within the loop, after sending an email, you set the content back to an empty string. You need to set it to the message and headings again. You then add the rows for the next customer.
Hello and thanks for the response. I have tried different ways from what i understand you said and all to no avail. If you can, use my code to clarify me pls. Thanks