I want to dynamically add images to the email body which will be sent bij dbmail.
Because of more departments en several marks the logo’s added to the email body need to be added dynamically base on user en department.
If now added a table with a link to the path, that works fine in the application but when sending it out the logo’s are empty, because of the pointer to the local path.
For one html table cell for example <td><img src="G:\Thinkwise\logo1.png”
I have stored the images in the database as well on department level, let’s say the field [department].logo
I’ve created an email-template with the tekst [handtekening]
When creating the email I replace the [handtekening] tekst with the complete email signature of the user.
When I put the logo directly in my email template, the logo is embedded in the template and that works, but that is not dynamic.
So the challenge is to add the code of the image stored in the [department].logo field (or the code of the image stored on the location “g:\thinkiwsie\logo1.png” into the body field of the email to be sent out.
I store each ‘to-be-sent’ in a email_send_list table and table has a field body (html type)
I hope anyone of you can give me a clue….
Best answer by Edwin SaanView original