Send Plain Text Email in Outlook

Hi All,

Hoping someone can offer some assistance. Basic situation: I have an excel 2007 spreadsheet that myself and my team complete to lodge new files. Once finished they press a button and the macro kicks in and it generates one email in Outlook 2007 (in HTML form - cuts and pastes a table) to a particular group. I am trying to edit this spreadsheet so that a second email is generated to go to an Email to SMS service. I have been able to get it so the email comes up with the right information in the 'to' field and the right information in the body etc, but I can't seem to get it to send as a plain text, which it needs to or the SMS arrives as gibberish.

To clarify, I'm not a VBA expert and have largely created the macro using on code I've found online. I've spent two days googling and trying different options such as .TextBody, .BodyFormat, .olFormatPlain etc etc. None seem to work and I think its because of the code that I'm using to generate the email. I think I need to find the right combination but am struggling. The code I am using is:

Please Login or Register  to view this content.

Any assistance would be greatly appreciated.

Many thanks

Trav