random ! marks in email

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • n8kindt
    New Member
    • Mar 2008
    • 221

    random ! marks in email

    ok, i've done quite a bit of research on my problem here. random "! " will appear in my email that i'm sending thru cdo. i've learned that this problem occurs when there are long lines of html (or rich text in my case) of 512 characters or more. i've found multiple places that state the following:

    "We have identified errors occurring in Outlook where the HTML message contains a long line of code of
    over 512 characters without a line break. Typical errors that occur are exclamation marks appearing in the
    HTML at 512 characters on the line. To avoid this simply break up the HTML code onto separate lines so
    that all systems can parse it."

    my question: how do i break up the code? i've tried putting <html> and </html> around the message in smaller areas but nothing happens. i've also seen that inserting a new line by using "\n" i supposed to help but i can't get it to work.

    here's my code:

    PLEASE NOTE: i did not put all the [font] [size] code into this post. when i pasted it into this thread it did it all by itself. please disregard them. i am attaching the actual code i am using with this post. click here to download it.

    Code:
    .htmlbody = "<html>[font=Arial][size=3]Congratulations on your decision to join _____![/size][/font] 
    " & _
    "<div>[font=Arial][size=2] [/size][/font][font=Arial][size=2][font=Arial][size=2]Your _____ account has been activated! _____ is a powerful tool that allows you to make _____ " & _
    "purchases online, set up events, download important forms, blog, and much more! Your account has been created with the following information:</font>[/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]" & _
    "</div>[/size][/font][/size][/font][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]First Name: " & [Reports]![rptFInalizedApp]![First] & _
    "</div>[/size][/font][/size][/font][font=Arial][size=2][font=Arial][size=2]Last Name: " & [Reports]![rptFInalizedApp]![Last] & "[/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]Username/GG Email: " & _
    strGGemail & "</div>[/size][/font][/size][/font][font=Arial][size=2][font=Arial][size=2]Password: " & strAssignedPW & "[/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]Zip Code: " & [Reports]![rptFInalizedApp]![Zip] & _
    "</div>[/size][/font][/size][/font][font=Arial][size=2][font=Arial][size=2]Phone#: " & Left([Reports]![rptFInalizedApp]![Phone1], 14) & "[/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]" & _
    "<div> [/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]If you wish to change your password, you can do so after logging in. To login into your _____ account, please follow these instructions:[/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]" & _
    "<html>[/size][/font][/size][/font][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2]1) Go to [url="http://www._____.info"]www._____.info[/url] either by <\\n>copying the url into your web browser (preferably Internet Explorer) " & _
    "or clicking on the link provided.</div>" & _
    "<div>[font=Arial][size=2]2) After reviewing the Corporate Policy and terms, scroll to the bottom of the page. You will now see a place to enter your username ( " & _
    strGGemail & " ) and password ( " & strAssignedPW & " ).</font>[/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]3) Click login. " & _
    "A small window should pop up and read: "Successfully Logged In!" If this does " & _
    "not appear, click "Logout of Site" (located below the solid pink bar) and follow the instructions listed under "Troubleshooting" on the main page.</font>[/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]" & _
    "<div>[font=Arial][size=2]4) [b]This step is ONLY for new recruits who have not yet purchased their kits:[/b] After logging in, click the "Store" link at the top of the webpage. " & _
    "You will now be viewing the store. Click on "New Recruits Click HERE". <\\n>Now add BOTH "[u]Your Kit Size[/u](1 of 2):Product" and " & _
    ""<u>Your Kit Size(2 of 2): Supply" to your cart. We will not ship your order until you have purchased both.[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]" & _
    "<div> [/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]If you want to change your password, click on the "Admin" link. Once the page has loaded, click "Update your login password" under " & _
    "the heading "Reset password".</font>[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]Your _____ username is also an email forwarder. " & _
    "All emails sent to " & strGGemail & " will be forwarded to " & Email.Value & ".</font>[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]If any of this is information " & _
    "is incorrect, please reply to this email address with the corrected information. </font>[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]We look forward " & _
    "to receiving your orders from the WebStore and processing them for you. Have a blessed day!</font>[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2]_____ Webstore " & _
    "Support</font>[/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]
    [font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2][font=Arial][size=2] [/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font][/size][/font]


    and this is the output in an email:

    Code:
    Congratulations on your decision to join _____!
     
    Your _____ account has been activated! _____ is a powerful tool that allows you to make _____ purchases online, set up events, download important forms, blog, and much more! Your account has been created with the following information:
     
     
    First Name: test
    Last Name: test
    Usernamel: test.test@_____.com
    Password: 0vq2340
    Zip Code: 66666
    Phone#: (555) 555-5555
     
    If you wish to change your password, you can do so after logging in. To login into your _____ account, please follow these instructions:
     
    1) Go to www._____.info either by copying the ! url into your web browser (preferably Internet Explorer) or clicking on the link provided.
    2) After reviewing the Corporate Policy and terms, scroll to the bottom of the page. You will now see a place to enter your username ( test.test@_____.com ) and password ( 0vq2340 ).
    3) Click login. A small window should pop up and read: "Successfully Logged In!" If this does not appear, click "Logout of Site" (located below the solid pink bar) and follow the instructions listed under "Troubleshooting" on the main page.
    4) This step is ONLY for new recruits who have not yet purchased their kits: After logging in, click the "Store" link at the top of the webpage. You will now be viewing the store. Click on "New Recruits Click HERE". Now add BOTH "Your Kit Size(1 of 2):Product"! ; and "Your Kit Size(2 of 2): Supply" to your cart. We will not ship your order until you have purchased both.
     
    If you want to change your password, click on the "Admin" link. Once the page has loaded, click "Update your login password" under the heading "Reset password".
     
    Your _____ username is also an email forwarder. All emails sent to test.test@_____.com will be forwarded to _____________.
     
    If any of this is information is incorrect, please reply to this email address with the corrected information.
     
    We look forward to receiving your orders from the WebStore and processing them for you. Have a blessed day!
     
    _____ Webstore Support
    when i look at the source code in the email itself, it looks something like this (all one line):

    Code:
     <script>document.getElementById("MsgContainer").innerHTML='\x3cdiv\x3e\x3cfont face\x3dArial size\x3d3\x3eCongratulations on your decision to join _____\x21\x3c\x2ffont\x3e \x3c\x2fdiv\x3e\x3cdiv\x3e\x3cfont face\x3dArial size\x3d2\x3e\u00a0\x3c\x2fdiv\x3e\x3cdiv\x3e\x3cfont face\x3dArial size\x3d2\x3eYour _____ account has been act....
    how am i supposed to make it two lines if the email client always uses one line? this seems to be a microsoft exchange server error so i'm hoping someone can help me find a solution/workaround to this problem.

    thank you,
    nate
    Attached Files
  • n8kindt
    New Member
    • Mar 2008
    • 221

    #2
    wow i just got home and this post looks way different than my computer at work. sorry for the extra wide post. i think the new firefox kept it from appearing so wide on my other computer. and by the way, there are only two "! " in this particular email: on lines 15 and 18.

    Comment

    • Stewart Ross
      Recognized Expert Moderator Specialist
      • Feb 2008
      • 2545

      #3
      Hi Nate. I reckon that when you are building your string you need to add explicit line breaks (end-of-line markers) to prevent your string being seen as one long block of characters exceeding 512 characters per line. The guidance you have found on the error points the way.

      A line break is what is placed in text when you press the enter key in a text editor. It is a carriage return/line feed combination which is an explicit end-of-line marker. There is a pre-defined VBA Long constant for this - vbCrLf - which is the equivalent of the two ASCII control characters in one value.

      To use it within your text just concatenate it where you want a new line to start:
      Code:
      yourmessage = yourmessage & "more joining instructions." & vbCrLf & "And on a new line..." & vbCrLf & "Starting the next line..." & ...
      -Stewart

      Comment

      • n8kindt
        New Member
        • Mar 2008
        • 221

        #4
        Originally posted by Stewart Ross Inverness
        Hi Nate. I reckon that when you are building your string you need to add explicit line breaks (end-of-line markers) to prevent your string being seen as one long block of characters exceeding 512 characters per line. The guidance you have found on the error points the way.

        A line break is what is placed in text when you press the enter key in a text editor. It is a carriage return/line feed combination which is an explicit end-of-line marker. There is a pre-defined VBA Long constant for this - vbCrLf - which is the equivalent of the two ASCII control characters in one value.

        To use it within your text just concatenate it where you want a new line to start:
        Code:
        yourmessage = yourmessage & "more joining instructions." & vbCrLf & "And on a new line..." & vbCrLf & "Starting the next line..." & ...
        -Stewart
        thanks, Stewart! that did the trick. out of curiousity, when you say it is the equivalent of the two ASCII control characters are you referring to chr(10) and chr(13)? THANKS again!

        --nate

        Comment

        • Stewart Ross
          Recognized Expert Moderator Specialist
          • Feb 2008
          • 2545

          #5
          Hi Nate. Yes, vbCrLf is equivalent to the two ASCII control characters represented in a string as Chr(13) (Carriage Return) and Chr(10) (Line Feed).

          -Stewart

          Comment

          Working...