Solved

HTML in email body has extra  tick marks

Posted on 2016-09-20
3
94 Views
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 ?

Thanks
fordraiders
0
Comment
Question by:fordraiders
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Big Monty earned 500 total points
ID: 41807417
the variables themselves don't contain quotes, do they?
0
 
LVL 3

Author Comment

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

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

now is

"Account #: " & esc_AccountNumber & "<br>" & _
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 41807668
thanks !!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

713 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