Dynamic text blocks

Choose in menu Edit - Dynamic text blocks. This option is only available in the Professional versions.

You can create dynamic text blocks to use contents of SQL tables in your email text directly. You must have SQL knowledge to create text blocks.

You can create an unlimited number of text blocks. All text blocks are valid for any project because they will be stored in the registry of windows system.

Adding new text block

1. Click on "Add", to create a text block.
   
   
2. Give your new text block an unique name that is be used as a placeholder.
   
   
3. Create the connection with the SQL database.
   See also: Import from database
   
   
4. Create your SQL query and test it.
   The SQL query must return an unique result that SuperMailer can be use in the email text.
   
5. Click on "OK", to store the text block.

Change a text block

1. Select the text block that you want to change and click on "Edit".
   
   
2. The next steps are the same as adding a text block.

Remove a text block

1. Select the text block that you want to remove and click on "Remove"

See also
Text blocks
Import from database