Mailin Database Owner - Inconsistent "From"

We have a mailin database where we have put the owner name in as, for example, “XXXXX”. Sometimes when we create a memo from this database, we are getting inconsistent results:1. The email is from XXXXX with my name as the Sent By - when the user clicks on Reply it goes to XXXXX (preferred)

  1. The email is from XXXXX but with Sent To with my name and it is stored in my Sent box - the user clicks on Reply and it goes to me, not XXXXX (not wanted)

  2. The email appears to be from me and it is in my Sent box, replies to go me (not wanted).

We want the following situation:

  • emails to users appear to be coming from XXXXX (ok if Sent by is me)

  • emails are stored in XXXXX’s sent box

  • replies from users auto-populate XXXXX in the To:

  • this would occur if using Create Memo, and any Send functionality we build.

  • in most cases we will be sending an email from this mailin db from a form, so we have altered the Mail and Reply to inherit three fields from the work request form (ie, a reference number and subject). This allows us to store the form and all corresponding email together within this database.

I have worked with this for a while and cannot figure out what is causing the inconsistency.

Note: I have even tried altering all of the fields that remotely look like a “from” and hardcoded in XXXXX, but when I check the email at the user end, the app is putting in my address as the From and the inetFrom (even though I have hardcoded XXXXX everywhere I can think to do it).

Any help or suggestions would be appreciated.

Subject: Inconsistent From

I figured out a way to force it, for anyone else who might be interested in the future. I added a Principal and iNetPrincipal field and hardcoded the database name/email address in them. Of course, this only should be done in a custom application, not a regular mail file.