Manipulating Text in Send Object -> Message Text



Is there a way to do the following in the message text portion of a send
object macro?

1. add a line break after a sentnce
2. have a URL




Douglas J. Steele

You can add a line break like:

"This is the first sentence." & vbCrLf & "This is the second sentence, on a
separate line."

I assume by "have a URL", you mean you want a hyperlink that the recipient
can simply click on to open something in their browser. I don't believe
SendObject supports that, although whatever e-mail client you're using may
recognize URLs as hyperlinks.

Dirk Goldgar

Wink20TCU said:
Is there a way to do the following in the message text portion of a
send object macro?

Macro, not VBA code? Yes, in a macro you can set the Message Text
argument to an expression beginning with an equals sign (=), like this:

="Line 1 of message" & Chr(13) & Chr(10) & "Line 2 of message"

If you want a blank line between the two, add an extra Chr(13) & Chr10)

="Line 1" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "Line 2"
2. have a URL

I don't know what you mean. You can add a URL as part of the text of
your message body. If you begin it with "http://", then the receiver's
e-mail client will probably interpret it as a clickable hyperlink.


Jan 18, 2018
Reaction score
Hi. I have the same problem ("add a line break after a sentence") in TextMessage, in "Include database object in email message" Macro, but with Access in Office 365. I did try this: ="Line 1" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "Line 2", but it is not accepted. I can't believe that is not possibile to send a fixed text, with more than a line, with Access, to some email that are in a Access Table. It was possible with Access 2003.
Thanks in advance.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question