Answers.Body: <p>Not sure about how civirules stores it but the From addresses are just option values.</p>
  <p><code>select v.* from civicrm_option_value v inner join civicrm_option_group g on v.option_group_id=g.id and g.name='from_email_address';</code></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T21:52:57.370Z
Answers.Text: This got me what I needed. It appears that when you edit a FROM email address in the GUI, it changes the table civicrm_options_value > label but it also needs to change the > name column as well.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T21:53:59.887Z
Answers.Text: That sounds familiar - there might be an open labs ticket about that.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T21:55:57.853Z
Answers.Text: Ah I think this one: https://lab.civicrm.org/dev/core/-/issues/2995
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T21:56:54.690Z
Answers.Text: I am guessing tha tin the GUI I could have deleted the old entry and created a new one and solved the problem
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T22:03:07.240Z
Answers.Text: It sounds like the email api extension used to use the internal machine name instead of label but that's now fixed in its latest code. The GUI should _not_ change the internal machine name once it is set. So yes creating a new one would temporarily fix it, but the extension shouldn't use name for display purposes.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T22:10:34.750Z
Answers.Text: So CiviRules should be using label instead of machine name? Rather than the GUI changing both label and name so they match?
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T22:12:40.450Z
Answers.Text: If that is the case, how do you ever get rid of the "FIXME" in name of the civi default FROM address?
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T22:12:45.180Z
Answers.Text: The email api extension (which civirules uses). It's fixed as of about a week ago via that ticket above, but you'd have to use the git master version since there isn't a new release yet.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-02-26T21:07:16.313Z
Answers.LastActivityDate: 2022-02-26T21:07:16.313Z
Answers.UserDisplayName: Demerit
Body: <p>In Administer &gt; Communication &gt; FROM Email Addresses, I have changed the persons name associated with our donations@xyz.org email. However, receipts still have the old name associated with it. I am using a CiviRule to send a Message Template and the selection FROM Email shows the proper name, but it send the old name. Where in the database do I find this information so I can make sure it is properly cleaned up?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-02-26T21:30:04.020Z
Comments.Text: does changing the civirule to a different From address and then back again help?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-02-26T21:32:09.860Z
Comments.Text: otherwise see if you have the old value in the civirule_rule_action table
Comments.UserDisplayName: petednz - fuzion
Tags: <email><receipts>
Title: Which SQL table stores the FROM Email Addresses?
ThreadText: # Which SQL table stores the FROM Email Addresses?
  
  (Asked by: username_0 on 2022-02-26)
  
  In Administer > Communication > FROM Email Addresses, I have changed the persons name associated with our donations@xyz.org email. However, receipts still have the old name associated with it. I am using a CiviRule to send a Message Template and the selection FROM Email shows the proper name, but it send the old name. Where in the database do I find this information so I can make sure it is properly cleaned up?
  
  **Tags:** email, receipts
  
  > **Comments:**
  > **username_1**: does changing the civirule to a different From address and then back again help?  
  > **username_1**: otherwise see if you have the old value in the civirule_rule_action table  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2022-02-26. Score: 1 | Accepted answer
  
  Not sure about how civirules stores it but the From addresses are just option values.
  
  `select v.* from civicrm_option_value v inner join civicrm_option_group g on v.option_group_id=g.id and g.name='from_email_address';`
  
  > **Comments:**
  > **username_0**: This got me what I needed. It appears that when you edit a FROM email address in the GUI, it changes the table civicrm_options_value > label but it also needs to change the > name column as well.  
  > **username_2**: That sounds familiar - there might be an open labs ticket about that.  
  > **username_2**: Ah I think this one: https://lab.civicrm.org/dev/core/-/issues/2995  
  > **username_0**: I am guessing tha tin the GUI I could have deleted the old entry and created a new one and solved the problem  
  > **username_2**: It sounds like the email api extension used to use the internal machine name instead of label but that's now fixed in its latest code. The GUI should _not_ change the internal machine name once it is set. So yes creating a new one would temporarily fix it, but the extension shouldn't use name for display purposes.  
  > **username_0**: So CiviRules should be using label instead of machine name? Rather than the GUI changing both label and name so they match?  
  > **username_0**: If that is the case, how do you ever get rid of the "FIXME" in name of the civi default FROM address?  
  > **username_2**: The email api extension (which civirules uses). It's fixed as of about a week ago via that ticket above, but you'd have to use the git master version since there isn't a new release yet.  
  
  ---
  
  