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
  • 2
LVL 32

Accepted Solution

Big Monty earned 500 total points
Comment Utility
the variables themselves don't contain quotes, do they?

Author Comment

Comment Utility
no,, not from rst..
but i just noticed code with '

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

now is

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

Author Closing Comment

Comment Utility
thanks !!

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now