Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


HTML in email body has extra  tick marks

Posted on 2016-09-20
Medium Priority
Last Modified: 2016-09-20
I had this question after viewing take current email text PLUS recordset and make it into HTML.

I have in my email  extra tick marks in the body:

Request #:'11' 
Quote #:'3232323232'
Account #:'555555555'
Account Name:'dept of youth'

Open in new window

 mybody = mybody & "Request #:'" & price_escNum & "' <br>" & _
    "Quote #:'" & esc_Quote & "'<br>" & _
    "Account #:'" & esc_AccountNumber & "'<br>" & _
    "Account Name:'" & esc_AccountName & "'<br><br>" & _
    "Please Note one or more of the Target Prices is below cost.<br><br>"
    mybody2 = "</table><p>Sincerely,<br><br>"
    mybody2 = mybody2 & "The CSP Quotations Team.</p>"

Open in new window

Is there a way to get rid of them ?

Question by:fordraiders
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 33

Accepted Solution

Big Monty earned 2000 total points
ID: 41807417
the variables themselves don't contain quotes, do they?

Author Comment

ID: 41807665
no,, not from rst..
but i just noticed code with '

"Account #:'" & esc_AccountNumber & "'<br>" & _

now is

"Account #: " & esc_AccountNumber & "<br>" & _

Author Closing Comment

ID: 41807668
thanks !!

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question