Answers.Body: <p>When sending some emails, such as using CiviRules and the MailAPI extension, the display name of the specified from email address option is being read from the non-ui editable Name column, while the email address is read from the Label column. This results email being sent with the display name of FIXME when using the from email address that was created during the initial CiviCRM set-up.  The Name of the first created email address is &quot;FIXME&quot; &lt;info@example.com&quot;&gt; and is not editable via the user interface.</p>
  <p>This record can be updated by editing option_group_id 31 value 1 in the database.  An easier option might be to just create a new from address and delete or at least not use the original, and then make sure to update wherever that from address was used.</p>
  <p>This behavior seems to be the result of two separate flaws, so I have submitted an issue to both the <a href="https://lab.civicrm.org/dev/core/-/issues/2995" rel="nofollow noreferrer">Core</a> and <a href="https://lab.civicrm.org/extensions/emailapi/-/issues/24" rel="nofollow noreferrer">MailAPI extension</a> queues.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-16T16:35:39.270Z
Answers.LastActivityDate: 2021-12-16T19:45:06.860Z
Answers.LastEditDate: 2021-12-16T19:45:06.860Z
Answers.UserDisplayName: Larry K.
Body: <p>On 4.6.4 I recently spotted a client where a Scheduled Reminder was be sent using  From Address = 1
  In the UI this was clearly correct ie it had the clients email in it. But they were arriving in inboxes from FIXME.
  Checking in the DB there is a Label field (which is all that is visible in the UI) and a Name field.
  Should the Name field be being updated to match the Label when one saves? If not is my system incorrectly using the Name rather than the Label when sending out emails?
  If not should the Name field be editable in the UI</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-10T03:07:03.660Z
Comments.Text: see http://civicrm.stackexchange.com/q/3825/186 which might be related, fix ID'd is an upgrade to 4.6.4
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-10T06:08:38.703Z
Comments.Text: Thanks Joe - not sure it is related, but I should flag that my issue above was on 4.6.4
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-10T13:16:55.940Z
Comments.Text: peter yeah thanks never mind I need to learn to read.
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-15T00:19:01.617Z
Comments.Text: I am also getting the FIXME display name when we send email from CiviRules and the Mail API. I looked in the database and could not find the table that has the From addresses. @petednz-fuzion or anyone, do you know which table it is? Thanks.
Comments.UserDisplayName: Larry K.
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-15T02:30:13.273Z
Comments.Text: I converted your Answer to a comment, since an Answer it was not. From Emails are just an option field/value ie under Admin > System Settings > Option Groups or via /civicrm/admin/options?gid=31&reset=1
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-15T02:33:01.207Z
Comments.Text: and i think the 'fix' for this actually means jumping in the db which isn't a good way of resolving it for general users
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-16T16:22:36.623Z
Comments.Text: Thanks, Pete, I found them.  The option_group_id = '31'.  The  Name for Value 1 was "FIXME" <info@EXAMPLE.ORG> while the Label has our correct display name and main email address.
Comments.UserDisplayName: Larry K.
Tags: <email>
Title: Why does From Email address '1' retain FIXME as its name in the db
ThreadText: # Why does From Email address '1' retain FIXME as its name in the db
  
  (Asked by: username_0 on 2015-07-10)
  
  On 4.6.4 I recently spotted a client where a Scheduled Reminder was be sent using From Address = 1
  In the UI this was clearly correct ie it had the clients email in it. But they were arriving in inboxes from FIXME.
  Checking in the DB there is a Label field (which is all that is visible in the UI) and a Name field.
  Should the Name field be being updated to match the Label when one saves? If not is my system incorrectly using the Name rather than the Label when sending out emails?
  If not should the Name field be editable in the UI
  
  **Tags:** email
  
  > **Comments:**
  > **username_1**: see http://civicrm.stackexchange.com/q/3825/186 which might be related, fix ID'd is an upgrade to 4.6.4  
  > **username_0**: Thanks Joe - not sure it is related, but I should flag that my issue above was on 4.6.4  
  > **username_1**: peter yeah thanks never mind I need to learn to read.  
  > **username_2**: I am also getting the FIXME display name when we send email from CiviRules and the Mail API. I looked in the database and could not find the table that has the From addresses. @petednz-fuzion or anyone, do you know which table it is? Thanks.  
  > **username_0**: I converted your Answer to a comment, since an Answer it was not. From Emails are just an option field/value ie under Admin > System Settings > Option Groups or via /civicrm/admin/options?gid=31&reset=1  
  > **username_0**: and i think the 'fix' for this actually means jumping in the db which isn't a good way of resolving it for general users  
  > **username_2**: Thanks, Pete, I found them.  The option_group_id = '31'.  The  Name for Value 1 was "FIXME" <info@EXAMPLE.ORG> while the Label has our correct display name and main email address.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-12-16. Score: 3
  
  When sending some emails, such as using CiviRules and the MailAPI extension, the display name of the specified from email address option is being read from the non-ui editable Name column, while the email address is read from the Label column. This results email being sent with the display name of FIXME when using the from email address that was created during the initial CiviCRM set-up. The Name of the first created email address is "FIXME"  and is not editable via the user interface.
  
  This record can be updated by editing option\_group\_id 31 value 1 in the database. An easier option might be to just create a new from address and delete or at least not use the original, and then make sure to update wherever that from address was used.
  
  This behavior seems to be the result of two separate flaws, so I have submitted an issue to both the [Core](https://lab.civicrm.org/dev/core/-/issues/2995) and [MailAPI extension](https://lab.civicrm.org/extensions/emailapi/-/issues/24) queues.
  
  
  ---
  
  