I am not sure I understand; you have your CDO object setup properly so, i guess, you are asking how to get the form data from the posted form?? Thats as simple as using Request.Form and then connect to SQL and use a recordset to get the data you need.
Just append all of your markup and data to a single string then place that string as the value for HTMLBody.
sHTML = "<B>" & Request.Form("field") & "</B>"
sHTML = sHTML & "<I>" & rs("field") & "<I>"
myMail.HTMLBody = sHTML
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
Read this if you want to know how to get a correct reply for your question:
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^