+ Reply to Thread
Results 1 to 5 of 5

Outlook email from Excel VBA - message format & importance

  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    32

    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
    Last edited by ssu95bm; 02-08-2012 at 10:34 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

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

    Like this:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

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

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



  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

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

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

  5. #5
    Registered User
    Join Date
    01-10-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    32

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

    Thanks everyone, using the following as suggested has worked a treat!

    Please Login or Register  to view this content.
    Cheers,
    ssu95bm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1