We developed an application in a mailin database, where in the form that a user selects an email address that they want to email the form contents from to a vendor. The vendor will only accept email address that come from this form. No matter what hard-coding we put into the email functionality we coded into the form “submit” button, the email always comes from the user name specifically (although we have been successful in hard-coding the memo form to at least send it from the database name, but it is a generic database and we don’t want that). We have tried hardcoding Principal, NetiPrincipal, Altfrom, Dispfrom,etc., none work).- Is there another field that we can hard code into either the Submit functionality in the form, or within the Memo form itself that will send from the email address the user selected in the form?
As a workaround, since we are able to force it to send from the database name, we could set up a database for each of the potentially selected addresses (not great because that would be 20 or so). Then, based on what the user selects as the From email address, it will send an email to the appropriate secondary database. We would like to set up a mail rule that would forward it on to the vendor. There is only a Send Copy To rule, and this just sends an identical email from the first database with the from still being from the User, not the secondary database name.
-
Is there some coding we could put into a mail rule that will Forward, not Send Copy To
-
We don’t want to do a scheduled agent, because the From then becomes the email address of the person who signed it, again, not the person we want.
A final idea set up a database for each of the email addresses and have the users go to the correct database (this isn’t very effective), but then we would have to maintain the exact same form in each database and would become a Change Management nightmare.
Any ideas or help would be greatly appreciated.