Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mail merge like functionality

ABD - DBAMar 11 2009 — edited Mar 11 2009
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2009
Added on Mar 11 2009
7 comments
1,177 views