Inserting a carriage return

[Guest]

Using SendObject I have in the correct syntax:

,"this is my text in the message body",True

I want to insert a carriage return and have tried:

,"this is my text"& vbCrLf &"the message body", True

Which does not work. Can anyone correct me OR is it not possible to do this
in this case?

Thank you

 

[SusanV]

It certainly ought to work and looks ok - for debugging put it in a variable
and use debug.print:

dim b as string

b = "first Line"
b = b & vbCrLf & "SecondLine"
debug.print b

You should see in the immediate window:

Fist Line
Second Line

Once you get the variable to look as you wish for the message body, use the
variable in your docmd line.

 

[Guest]

Thank you Susan, putting the string together and declaring as a variable
worked. I don't understand why it did not work as a straight string but
be-it-as-it-may, the problem is resolved and I have the solution for the next
time I need it. I appreciate your help so quickly.

 

[Guest]

The solution was putting it a variable I guess, just as you suggested. I
appreciate your help. Don't know why the straight string didn't work but,
thank you.

 

[SusanV]

Glad to help any time!

;-)

SusanV

Thank you Susan, putting the string together and declaring as a variable
worked. I don't understand why it did not work as a straight string but
be-it-as-it-may, the problem is resolved and I have the solution for the
next
time I need it. I appreciate your help so quickly.