Mail merge like functionality
Is there anyway to create a mail merge functionality in Apex. In the simplest form I need to create form letters, with variables that are populated such as, the variables are in upper case.
Dear P1_CUSTOMER_NAME,
We are contacting you about order P1_ORDER_NUMBER. blah blah blah.
Please contact us at P1_ PHONE_NUMBER for questions.
thanks
Any ideas? I know I can build it via pl/sql program unit but that gets ugly
:p1_text :='Dear '||P1_CUSTOMER_NAME||
We are contacting you about order '||P1_ORDER_NUMBER||'. blah blah blah.
Please contact us at '||P1_PHONE_NUMBER||' for questions.
thanks'
I'm trying to avoid that, some thing a user could take care of.
I discovered I could do it if I populate the "source value or expression" field of an item, but that requires a programmer.
Any other ideas?