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