Email signature with HTML and SQL

Michiel de Nooijer

Hi,

We are looking for a solution when we sent a document from SAP using designer, we want to customize the email signature as stated below:

We use the field "Email Text" in HTML mode:
We have emdeded the company logo and some text using HTML also we need to select data from the database such as the username, telephone numeber etc.

Could someone provide an example how to combine the HTML code for layout as for example line breaks, text format, the logo, etc. and between some fields which are selected from the SAP database using a select query.

Thank in Advance.

R. Michiel

Philipp Knecht

Hi Michiel

Provide an SQL Staement like SELECT 'Text1' + ' ' + firstName +
FROM OUSR WHERE USER_CODE = '[%UserId]'...

Rule: It has to be a valid Query or an Text with placeholders -> You can not mix!


It should aslo be possible to add Images to this Signatur by using approach as described on:

http://stackoverflow.com/questions/342554/how-to-embed-image-in-outlook-signature

hth