Email from Excel 2007 Question

Hey guys,

I got some help from Ron at http://www.rondebruin.nl/mail/folder3/mail2.htm.

My code looks like this (straight off the website with the only changes being my name as the address on the "To:" line.

Please Login or Register  to view this content.

It works and sends me an email but it is cutting off about 90% of it. I attached what it looks like (PartialExcelEmail.jpg).

I also attached what the email is supposed to look like in the Excel Spreadsheet (Email Test)


I am pretty sure the problem is in the second half where the range is identified:

Please Login or Register  to view this content.

Any suggestions would be extremely helpful.

Thanks in advance!

Well I figured out what was chopping off most of my words...

The columns had to be extended all the way out so I highlighted all and double clicked a column to extend all of them automatically.

The picture still isn't going through though.. Any thoughts?

..And I got it to work with the picture.

http://www.rondebruin.nl/mail/folder3/mailenvelope.htm