I have a form used to send emails via mail merge. Normally, when I want to update a table, I need to send pertinent information to server via a context object, which can contained field names and values, and the server can use this to update tables (among other things).
In this case, I can put SendToAddresses, CcAddresses, BccAddresses and EmailSubject values into the context, because they are somewhat finite in length.
What I can’t figure out is how to convey the EmailBodyText to the server. It doesn’t seem safe to send the contents of a memo field via context, as it can be quite long.
Just so you know the architecture, I have an EmailTypes table, with EmailTypesKey (GENERIC, BOARD and LEADERS), EmailType (descriptive text), DefaultSubject and DefaultBody (memo).
When I show one of the email types on the form, the DefaultSubject and DefaultBody text are loaded into unbound Subject and Body form fields. Here the user can modify them before sending the email.
But again, the Body field can be quite long, so how do I get it to the server so the emails can be sent by the server?
The 3 records with defaults are fine like they are, but since this will be a multi-user application, I need a way to save the modified text along with the current UserKey, just until the email is sent, so it doesn’t collide with other users.
What is the Five-approved way to do this? Thanks…