{"id":53108,"date":"2023-06-25T16:13:08","date_gmt":"2023-06-25T15:13:08","guid":{"rendered":"https:\/\/ekiwi-blog.de\/53108\/vba-outlook-format-e-mail-as-html\/"},"modified":"2023-06-25T16:31:03","modified_gmt":"2023-06-25T15:31:03","slug":"vba-outlook-format-e-mail-as-html","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/53108\/vba-outlook-format-e-mail-as-html\/","title":{"rendered":"VBA Outlook: Format e-mail as html"},"content":{"rendered":"

Anyone who does a lot of programming with the VBA<\/abbr> editor in order to write a few macros that automate recurring tasks will quickly come into contact with the MailItem<\/em>.<\/p>\n

The MailItem<\/em> represents the object of the respective e-mail in the code editor. You can assign various properties to it. For example, you can mark selected e-mails as read<\/a> with a VBA macro or write an automatic reply to an e-mail. One would then also like to assign the correct formatting, e.g. HTML, to such an automatic reply e-mail, as HTML offers considerably more design options than a pure text e-mail.<\/p>\n

Use BodyFormat<\/em> property<\/h2>\n

To achieve HTML formatting, one must use the BodyFormat<\/em> property, as shown in the following image and code example.<\/p>\n

\"Screenshot
Assign the HTML format to BodyFormat property<\/figcaption><\/figure>\n
Sub<\/span> ReplyMSG()\r\n    Dim<\/span> olItem As<\/span> Outlook.MailItem\r\n    Dim<\/span> olReply As<\/span> MailItem\r\n    \r\n    For Each<\/span> olItem In<\/span> Application.ActiveExplorer.Selection\r\n        Set<\/span> olReply = olItem.Reply\r\n        olReply.BodyFormat = olFormatHTML\r\n<\/mark>        '...more code here<\/span>\r\n    Next<\/span> olItem\r\nEnd Sub<\/span><\/code><\/pre>\n
In the sample code, reply mails are generated for all emails marked in the inbox and each MailItem<\/em> of the reply mail is assigned the html format via the BodyFormat<\/strong> property (olFormatHTML<\/em><\/strong>).<\/p>\n
BodyFormat<\/em> is an enumeration, which means that you can also simply assign the appropriate numerical value. Besides olFormatHTML<\/em> there are the following:<\/p>\n
    \n
  • \n
      \n
    • olFormatUnspecified <\/em>(value 0): no specific formatting<\/li>\n
    • olFormatPlain <\/em>(value 1): the mail object is formatted as text-only<\/li>\n
    • olFormatHTML <\/em>(value 2): Mail is formatted as HTML<\/li>\n
    • olFormatRichText (value 3): <\/em>Mail is output in rich text format, which also offers design options like html.
      \n<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Note:<\/strong><\/p>\n
      In order for the code execution to work properly in Outlook, the following must be set under “Tools” \u27a4 “References”<\/em> the correct libraries must be selected.<\/p>\n
      \"Screenshot
      Set the required library under Tools \u27a4 References<\/figcaption><\/figure>\n
      Now you can continue working with olReply<\/em> and assign text in the form of HTML code, for example.<\/p>","protected":false},"excerpt":{"rendered":"
      Anyone who does a lot of programming with the VBA editor in order to write a few macros that automate<\/p>\n","protected":false},"author":2,"featured_media":6532,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[2252,1707,2737,1857,1858,2168,1569,1861,2715,1862,2068],"class_list":["post-53108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-code-en","tag-macro","tag-macros","tag-microsoft-en-2","tag-microsoft-office-en-2","tag-office-en","tag-outlook-en","tag-vba-en-2","tag-vba-code-en","tag-visual-basic-for-application-en-2","tag-windows-en-2"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/53108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=53108"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/53108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/6532"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=53108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=53108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=53108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}