+ Reply to Thread
Results 1 to 4 of 4

Email Macro not formatting correctly

  1. #1
    Registered User
    Join Date
    09-22-2015
    Location
    Eau Claire, WI
    MS-Off Ver
    2010
    Posts
    65

    Email Macro not formatting correctly

    Hello all,

    I have an email macro that is not formatting correctly. Anyone know how I can ensure I string together the form references while putting new paragraph's where I want them? The main question here, is why when I insert a <br> code into my .htmlbody, it does not seem to be reading it at all. I have tried various recoding strategies and continue to come up short.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email Macro not formatting correctly

    Hi jdoerr1021,

    Can you provide any of the actual code used? It could be syntax but it is hard to know without seeing something to work with?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    09-22-2015
    Location
    Eau Claire, WI
    MS-Off Ver
    2010
    Posts
    65

    Re: Email Macro not formatting correctly

    The body of the email is coded as follows:
    Please Login or Register  to view this content.
    I had to remove the HTML code as the site does not allow it to be posted. However I detail font style, size and color throughout.

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Email Macro not formatting correctly

    when you insert a <br> into strBody you are wrapping that in quotes right? any html tags need to be in quotes when building the string I also find it is often best to make sure you have pre-formatted text tags... so .hmlbody = "<PRE>" & strbody & "</PRE>" This has solved issues for me in the past with formats not displaying in the final email.
    Last edited by Arkadi; 11-10-2016 at 09:47 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting not copying over correctly into body of HTML email
    By seaottr in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 04-10-2017, 01:01 PM
  2. VBA formatting macro that worked in Excel 2010 is not working correctly in Excel 2013
    By jayar2112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2015, 01:14 PM
  3. Data Bars of Conditional formatting not copying over correctly into body of HTML email
    By astha.malik1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-18-2014, 04:39 AM
  4. [SOLVED] Email VBA Not formatting Correctly in sent email
    By gillyr7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2013, 02:16 PM
  5. conditional formatting macro - doesnt work correctly
    By camar0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2011, 07:09 PM
  6. Macro Creating Email formatting
    By gambinus2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2008, 01:14 PM
  7. [SOLVED] Macro not formatting correctly
    By js8373 in forum Excel General
    Replies: 0
    Last Post: 02-28-2006, 04:00 PM

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