Emailing Sheet via Outlook by VBA - Body is Missing from 1st email only

Hi,

I'm using the fantastic code written by Ron de Bruin, and taken/amended from his website at http://www.rondebruin.nl/win/winmail/Outlook/tips.htm to send excel worksheets out through outlook

In all cases when using the code the email generates and can be sent with the attachments sucessfully through outlook, however it's only with the second email that the message has anything in the body, for the first it's completely blank.

Usually I employ this in sending many email out to individuals, so I've learned to live with the issue and send the first manually which is still a huge timesaver. However now I need to send single emails only (and of course each now has the body missing for each and every one).

Any help in spotting why only the first email body would be blank would be much appreciated.

Cheers

David

Please Login or Register  to view this content.

Hi,

These two lines are in the wrong order:

Please Login or Register  to view this content.

If you Put the .HTMLBody line after the other one, then the first email will have a body.

Thanks,
Duncan

That works very well Duncandhu, many thanks.

David