Seeking IT oriented help(pretty newb stuff)

[DierwulfBL]

hey guys whats up, like i said before im pretty newb at these sorts of things, but here's my situation. I needed to make it so that these promo emails were dynamic and could be changed with a web interface i designed. Everything works all cool, im using CDO that runs daily but not everyone gets an email thats on the list.

Problem: CDO format uses plain text and html in the email message. I have a 2 columns in my table that hold this information (think varchar(4000)). The html information is held in the table and that displays just fine in the emails ive been sending to myself. Now here's my problem, for the life of me I can't get any formatting to work on the plain text. It's just one long line of text no breaks or anything.

Tried: i tried hard coding all the appropriate double quotes and VBCrLf. That just printed exactly what i had in the table out onto the plain text, no line breaks happened. My next approach was to use my own CR(#newline#) and try a replace. This yielded the same results as hard coding everything. Also tried using an "image" as the data type but that was just worthless

I'm stuck and i know there's some easy little trick so the top part of my promo emails isnt all jumbled together (ive gotten emails like this and always wondered why it was all fucked up). Any and all help is appreciated, I know someone has the answer out there, im just too newb and all my internet trawling hasnt paid off yet.

sample email:
------xxxxxx Content-Type: text/plain; Content-Transfer-Encoding: quoted-printable "Wedding Tips: How to Save Money without Showing It" &VBCrLf& "Here are a couple of tips from Online Bridal Store to help make your day extra special."&VBCrLf& " * When looking for wedding bands, try also looking at regular ring bands. Often times, you can find very similar rings at about 1/4 of the cost if it does not have the "wedding band" name attached to it." &VBCrLf& " * Booking the reception is often times the most expensive thing you will pay for during your wedding. Research sites as soon as possible. Reception halls charge the most for Saturday nights at 7pm. To save a little money, have your wedding a little earlier in the day, or on a Friday night instead." &VBCrLf& "Next Weeks Tip: Preparation for the Wedding Day" &VBCrLf&Product Highlights: Wedding Rings Handkerchief -- <!-- m --><a class="postlink" href="http://www.onlinebridalstore.com/Scripts/prodView.asp?idproduct=1509">http://www.onlinebridalstore.com/Script ... oduct=1509</a><!-- m --> Starlight Guest Book & Pen -- <!-- m --><a class="postlink" href="http://www.onlinebridalstore.com/Scripts/prodView.asp?idproduct=1082">http://www.onlinebridalstore.com/Script ... oduct=1082</a><!-- m --> Visit <!-- m --><a class="postlink" href="http://www.onlinebridalstore.com">http://www.onlinebridalstore.com</a><!-- m --> for great deals on thousands of bridal products. This message was sent to you by OnlineBridalStore.com. To unsubscribe from future mailings visit <!-- m --><a class="postlink" href="http://www.onlinebridalstore.com/mailtools/unsub.asp?email=farrahib@shaw.ca">http://www.onlinebridalstore.com/mailto ... <!-- e --><a href="mailto:ib@shaw.ca">ib@shaw.ca</a><!-- e --></a><!-- m --> ------xxxxxx Content-Type: text/html; Content-Transfer-Encoding: quoted-printable

html portion follows

Thanks in advance!