By StarkMike - 4/5/2007
I want to make sure that all of my messages I have created in the Messaging component adhere to the same standards... IE I want to make sure I am using the same Font in the body of all my messages... is there a way for me to review this information without having to open every message?
|
By StrataFrame Team - 4/5/2007
The font information is all stored within the RTF content of the message body. We don't store it by itself in the database, but you could easily write something that could cycle through the messages, load them into an RichTextBox and check the font, and create a list that you could look at. Other than that, I can't think of a way to go through them all.
|
By StarkMike - 4/5/2007
Ok.  How would I cycle through the messages?
|
By StrataFrame Team - 4/5/2007
You can do a query of the records within the MessageItems table. You can filter on the msg_prj_pk field to only gather messages for your project (which you can get from the MessageProjects table). Then, you can also filter on the msg_type; I think 1 is a message and 2 is a text value (not positive on that). Then, just pull the RTF string out of the msg_text property and you'll be able to parse it using the RichTextBox.
|
By StarkMike - 4/5/2007
Cool! Thanks!
|