HTML in email body has extra  tick marks

Posted on 2016-09-20
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 500 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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
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…
Suggested Courses

623 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