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 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

773 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