Need to create a multi Line string

[psbsmms]

I am sending an e-mail from a form with multiple text boxes that I need to show up in the message body of the e-mail as separate lines. I tried sendkeys, against recommendations to do so as a last resort but that didi not work either.

 

[oharab]

You need to build in some carriage returns:

I assume you have

strbody = me.txt1 & me.txt2 or something

try strbody=me.txt1 & vbCrLf & me.txt2

vbCrLf is a constant that represents a Carriage Return Line Feed (is new line!)


Hope that gets you on your way.

B ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[psbsmms]

It worked great thanks. The command vbCrLf is nowhere in the help of access or VBA where did you find it, is there a convient place to find the reference libary of VB commands?

 

[oharab]

I'm not sure where I learnt it, it's one of those things it seems I've always known!

If you press F2 in the code window you get the Object Browser. There are lots of constants in there, have a look in the "VBA.Constants" class.

The object browser is useful for looking up methods and properties of all the objects available.


Have fun!!!

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------