Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MailTo formula not including field results in memo

Status
Not open for further replies.

BetteBoop

Programmer
Jan 2, 2001
3
US
Have a response form with action button that has MailTo formula. Works well except value of text field does not display in mail memo sent to user. Even tried hidden, computed field of text field (thought I was clever -- not!)
Here's my formula:

SendTo :=@Unique(Authors);
CopyTo :="Bette Boop/";
Subject := "Status of your "+ @If(Subject="";ReportCategory;Subject) + " request";
Remark := "Your request referenced in the subject line has NOT been approved. The reason(s) for its not being approved: " + ComputedReason;
REM;
@MailSend(SendTo;CopyTo;""; Subject; Remark; "");
@Command ([FileSave]);
@Command ([FileCloseWindow])


Works like a charm except the "ComputedReason" field does not display in the body of the memo.

Would really appreciate your help. Thanks
 
The best reason I can think of is that ComputedReason is not typing to text. Try @Text(ComputedReason) and see if that works. Also, is the ComputedReason field Rich Text or plain Text? Notes seems to have a hard time with the former. "One fish, two fish,

Red fish, blue fish."
 
You may also need to convert the fields from RTF, to plain text for where you're placing them.
I wish my sentences could come out clearer!!!

Okay,
For example:
@If(Subject="";ReportCategory;Subject)
might need to be changed to:
@If(@Text(Subject)="";@Text(ReportCategory);@Text(Subject))
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top