Manipulating Text in Send Object -> Message Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks.
 
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.
 
In
Wink20TCU said:
Is there a way to do the following in the message text portion of a
send object macro?
Click to expand...

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
Click to expand...

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.
 
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.
 
Back
Top