ASPMail - structuring problem

Hello,

I need to create an email which is sent using ASPMail, but I'm having
trouble "structuring" the email properly.

This is basically what I do....

set rs = cn.execute (select * from products)

while not rs.eof
strbody = strbody & rs("prodname") & " " & rs("qty")
rs.movenext
wend

I then send this with "Mailer.BodyText = strbody". My problem is the
spacing - not all prodname's are the same length. I
cannot now have a FIXED number of spaces between prodname & qty, because
then all lines will not be aligned properly! I tried using len(prodname) and
then work out how many spaces I need, but for some reason that does not
want to work!!

Any advice,
T

Are you using Len(rs.Fields("prodname"), because rs.Fields("prodname") might be evaluated to a pointer, in which the length would always be 4. Cast it to a string first, although in ASP everything is a variant anyway.

VB Code:

Dim strProdName
...
strProdName = CStr(rs.Fields("prodname"))

Then Len(strProdName) should work.