Dynamic messages

Adding to what my colleague said, you can also force the parameters to be on a newline by editing the Message translation in the form, then typing:

{0}
{1}
{2}

Forcing a newline can be done by using the keyboard shortkey: Alt+Enter

I added the necessary parameters and it works great!

But now my issue is that I can only this message if I have 3 parameters to send through. I would’ve liked if I could specify one parameter in the message itself to keep it general. This way I could send a nested message as parameter via the control procedure and not be limited to 3 parameters.

Is there a way to achieve this?

You can attach one XML tag like <text> or <col> to one parameter like {0} and {1}. What you can do is append the text together into one parameter like so:

declare @msg_text varchar(100)
select @msg_text = '<text>' + @text_1 + @text_2 + @text_3 + '</text>'

This will then show the three texts together in 1 parameter. You can add these to your texts to for newlines:

1. Carriage return: 

2. Line feed: 


Do keep in mind that the texts cannot contain any characters XML doesn't support, like the character &. These characters need to be replaced. For example:

• ' should be replaced with &apos;
• " should be replaced with &quot;
• & should be replaced with &amp;
• < should be replaced with &lt;
• > should be replaced with &gt;

I was hoping for the ability to use multiple XML tags as one parameter (nested), but I guess I can still make it work with the above suggestions. 

Thanks!