title: How do I concatenate html as a string in VBA?
body: <p>I'm a newbie at VBA and html and I'm getting very confused.</p>
  
  <p>I'm trying to set a string variable to equal several concatenated html strings and control values. I can't figure out what I'm doing wrong.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>    htmlText = "&lt;HTML&gt;&lt;BODY bgcolor=#0b3767&gt; &lt;img height=""71"" width=""500"" alt=""Central Analysis Bureau, Inc. - Know Your Insureds"" src=""http://cabfinancial.com/images/logoEmail.png""&gt;"_
        &amp; "&lt;a href=" &amp; txtLink.Value &amp; "&gt;Volume " &amp; txtVolume.Value &amp; " Edition " &amp; txtEdition.Value _
        &amp; "&lt;/a&gt;" _
        &amp; txtHtml.Value &amp; "&lt;a href=""txtLink.Value""&gt;Click here to read the complete article&lt;/a&gt;" _
        &amp; "&lt;/BODY&gt;&lt;/HTML&gt;" 
  </code></pre>
  
  <p>htmlText is a String. txtLink, txtVolume, txtEdition, txtHtml are all Textbox Controls on a form.</p>