Manipulating Text in Send Object -> Message Text

[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.

 

[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]

In

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.

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s

 

[Stecco]

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.