Spacing error with Email Macro

The email macro I set up didn't work when I referenced the sendto from a cell in sheet 2; I changed it to reference an email address on sheet 1 and it worked with spacing errors.

I need to fix the spacing errors, and I need to be able to pull the email from sheet 2.


Code referencing sheet 2:

Please Login or Register  to view this content.

Code for email body, which has spacing errors:

Please Login or Register  to view this content.

Just to test the email I changed the line that was having troubles to reference sheet 1, and although it sent the email; the email had spacing errors.

Here is the email it sent:

Subject line: Students'points

Body Line: Students' points in my class Harley Peterson45 Ratino Sherrod35


I want it to send like this:

Students points in my class

Harley Peterson 45
Ratino Sherrod 35

etc....

hello.

When you are sending the message you are sending the message body as .htmlbody and as such any references to new lines should be in html code eg <br> or <p>.
though if you want to use the vbnewline you should send the message body as plain text eg .body. hope that clears it up the spacing.

cheers