Good Evening,
I’m attempting to write a letter template where the user can type the name of the recipient into a form and it will automatically be updated in multiple letters. I’ve labeled the table where the recipient’s name is “Info” and the table with the long text “Messages.” The Column where the name is is “Student” and the column where the message is is called “Message.” There are two other substitutions I want to do in these letters as well. Their columns would be “Greeting” and “Parent.”
This is what I have created thus far. I’ve been plugging it into the formula in the Message column in the Messages table. It’s not working at all.
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
[Message],
“Student”,
“Info[Student]”
),
“Parent”,
“Info[Parent]”
),
“Greeting”,
“Info[Greeting]”
)
Thank you for any assistance you can give.
Kat
LinkedIn
Twitter
