PLS HELP! - Display richtext field in e-mail via QuerySave

I have a richtext field, “Description”, on my form and need to display it in an e-mail message. I have the same code in both QuerySave and WebQuerySave and the field does display with WebQuerySave, but not with QuerySave.

I then added a computed “text” field called, “DescriptionText”, with the formula of Description. While I can see both the Description and DescriptionText fields are populated in the properties, neither will show in the QuerySave event in the e-mail. Here is my QuerySave event code:

tmpEmail:=@If(Status=“Requested”; “There is a new project is the IS Projects Database for review.” + @NewLine + @NewLine + "Project Name: " + Title + @NewLine + "Requestor: " + Reqstor + @NewLine + "Phone #: " + OfficePhoneNumber + @NewLine + "Department: " + Department + @NewLine + "Office: " + Office + @NewLine + "Project Description: " + DescriptionText; “unknown”);

tmpEmail2:=@If(Status=“Assigned”; "There is a new project assigned to you in the IS Projects database: " + Title + “.”; “unknown”);

@If(Status=“Requested” & RequestedEmailFlag=“”; @Do(@MailSend(“Patty Bennett/Notes”; “”; “”; "New IS Project : " + Title; “”; tmpEmail); @SetField(“RequestedEmailFlag”; “1”)) ; “”);

@If(Status=“Assigned” & AssignedEmailFlag=“”; @Do(@MailSend(Responsible; “”; “”; "New IS Project : " + Title; “”; tmpEmail); @SetField(“AssignedEmailFlag”; “1”)) ; “”)

Subject: RT items are not on a document until after the save

for client application

so I’m not surprised that they are not there in the QuerySave.

My first suggestion would be yo move your code to the POST SAVE and see if that helps.

I expect will need to keep teh code in WEB Query Save

which despite its name isnt quite the same :=)

Subject: RE: RT items are not on a document until after the save

Thank you. Since the webquerysave was working, I didn’t change that, but I did move the QuerySave to the Post Save as you suggested and that fixed the message. Thank you much!