E-Mail query results

[NISMOJim]

Sorry again, I don't understand how to enter it. Here's what I entered, getting a syntax error...
sBody = sBody & rst.Fields(1) & ", " & rst.Fields(2) &nbsp & " " & rst.Fields(3) & "<BR>"

[rpeare]

I haven't tested it but I assume you'd need a

& "nbsp;" &

wherever you wanted a space inserted.

[NISMOJim]

When I try it that way, it just adds nbsp; to the e-mail text between the name & company. I tried it without the quotes & get an error expecting end of statement (it doesn't like the semicolon). I left off the semicolon & still only get one space between the name & company instead of the three that I would like. Also tried putting the nbsp before the inserted spaces, and later tried it after the spaces & still only get one space out of it. Sure is frustrating for just a stupid bit of asthetics!

[rpeare]

if it took the everything but the semi colon try using the same code repeatedly


"nbsp" & "nbsp" & "nbsp"

for three spaces etc.

[NISMOJim]

Like everything else I've seen, when you put something in quotes, that is what shows up on the sheet. Like I mentioned above, I tried it without the quotes & without the semicolon and still don't get the extra spaces no matter how many times I add it to the code. Are you getting different results with the database copy I sent?

[rpeare]

Try this:

ok that was a failure

& #160 ;

but take out the space after the & and the space before the ; if you string several of them together you can create multiple spaces

Put this in wherever you want a space (has to be inside " marks")

[NISMOJim]

That makes so little sense to me. I never would have come up with that no matter how long I tried, but it works perfectly. Thanks for not getting tired of me & sticking it out to the end, I so appreciate it!