[RESOLVED] [2005] Advert

[warrenayen]

Hello All,

I've finished (pretty much), a nifty program for my company that sends out automated Advertisments that you set up using a template, some Items you select.

It pulls the information from SQL Server 2000, and then writes an HTML file (based on the template - the template has tags in it, like <!!!!HEADER!!!!>, that I use a stringbuilder to replace with more HTML code around the data).

Here is the problem - when I view the final HTML document that is going to be e-mailed, all comma's in the pulled data from SQL server are missing, so sentences run together. What is odder, is that commas in the footer HTML are fine (not pulled from SQL Server). Even odder still is some commas that I wrote myself directly in the template HTML file ARE also MISSING in the final one.

Here is an idea of what it's doing:

For Y = 0 To Me.tblMfg_Prod_Desc.Rows.Count - 1
    bodyString.AppendLine("<LI>" & Me.tblMfg_Prod_Desc.Rows(Y)("Mfg_Bullet") & "</LI>")
Next Y

That is where it's stripping out the commas. Why?