Inserting cfmail contents into a comments field
I have an application that will send out a cfmail (3 or 4 lines of content only). If is formatted in a table.
I also have a history log table where every transaction is recorded into a comments field. So when the cfmail is sent, a comment would be inserted into the history table with comments like 'Email sent to customer'. However, this comment is too plain, so they want to put the entire cfmail contents (3 or 4 lines) into the comments field.
How can I do this, including adding the table format/structure, into the comments ?
