Thread: Outlook email from Excel VBA - message format & importance

Hi there,

I already use Excel VBA to send emails via Outlook. I need to specify that the email format should be plain text (rather than html or rtf), and that the importance should be "high". Can anyone point me to the tabs / commands / whatever that I need to add to the VBA code in order to do this, please?

I had a look at Ron de Bruin's page but I couldn't see anything on these commands.

Any assistance would be appreciated - thanks!

ssu95bm

Like this:

With CreateObject("Outlook.Application").Createitem(0)
    .importance = 2
    .body = "your text body"
    .bodyformat = 1
    .display
End With

If you don't use htmlbody, the email will by default contain plain text.

@snb mine doesn't, all my emails are set up as HTML as default