Last post Feb 09, 2011 06:39 AM by pankajmonga
Feb 09, 2011 04:02 AM|sephiroth100|LINK
I'm looking for a solution to sending and storing a custom email and would like advice on techniques products that people have used to resolve the issue.
The requirement is two fold.
1) Product a custom email per user based on information in database.
I need to know how best to control the email body - is it just a case of using stringbuilder and method that interrogates the database to construct a string, or are there more spohisticated ways of achieving this.
2) Produce an email that is available to everyone and stored onsite to view.
i) For instance, I may want to produce an email as per 1) but the same for everyone. So I connstruct a body string and send the email.
ii) For people visiting the site, I want them to be able to click on a link to display lastest email and retrieve the last one sent. This could be a case of storing the last string in the database and retrieving it - it this the case or again, are there
better ways of achieving this?
Thanks in advance.
Feb 09, 2011 06:39 AM|pankajmonga|LINK
you can construct an xml and apply stylesheet while display. anoher option is to create and store an HTML text. both can be stored in database table column.