Answers.Body: <p>I just verified that a completed mailing (in my test installation of 5.5.3) will show up  in the draft/unscheduled list IF the original creator of the email is a deleted (permanently) user. Doesn't solve the problem but at least gives us a cause.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-19T19:48:34.297Z
Answers.Text: Thanks! I wonder if I can go into the database and add a user to them. I've told folks not to remove people, just change their permission level.
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-19T19:52:37.600Z
Answers.Text: I didn't fully test it someone who was only partially deleted (still recoverable). Maybe there's a chance you can restore the original contact. If not, I agree you should just be able to assign it directly in the database to make that connection again and pull them off the report.
Answers.UserDisplayName: RayWright
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-19T20:01:19.603Z
Answers.Text: I think they completely deleted the person, plus I'd have no idea who it was. I just assigned them all to my user account since it's easy to just input 1 as the user who did it. Now they're all gone from that list. :D
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-19T20:02:50.367Z
Answers.Text: Yay! Glad it all worked out!
Answers.UserDisplayName: RayWright
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-19T17:32:46.140Z
Answers.LastActivityDate: 2018-10-19T17:32:46.140Z
Answers.UserDisplayName: RayWright
Body: <p>We've got 27 emails that show as completed, have a report, etc; however, they are showing on the list of Draft/Unscheduled emails. What could be causing this to happen? I'm trying to clean up the back-end for the new volunteers who will be working with the site this year, but I don't want to delete emails that have actually been sent.</p>
  
  <p>We're on Drupal 7 and CiviCRM 5.5.3</p>
  
  <p><a href="https://i.sstatic.net/iXIue.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/iXIue.jpg" alt="CiviCRM screenshot"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-11T09:10:03.893Z
Comments.Text: Is this on CiviMail report or Activity report?
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-11T17:40:43.660Z
Comments.Text: If this is in CiviMail - what checkboxes are checked in the Mailing Status box for each menu item (Draft and Unscheduled Mailings vs. Scheduled and Sent Mailings)?
Comments.UserDisplayName: RayWright
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-12T10:09:51.453Z
Comments.Text: It's the page you get when your select the Unscheduled and Draft link under the Mailings menu item. 
  
  The only thing checked is the one for unscheduled and drafts or whatever it's called (sorry, don't have it right in front of me at the moment). Only a couple dozen out of hundreds of sent emails are showing on that page.
Comments.UserDisplayName: Jenni Simonis
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-12T21:06:03.547Z
Comments.Text: Now that I'm at the computer, I grabbed a screenshot to show where it's at and what is clicked.
Comments.UserDisplayName: Jenni Simonis
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-19T17:17:54.440Z
Comments.Text: The screenshot is helpful - is see it's not respecting that 'draft / unscheduled' checkbox. Since it's only a couple dozen, maybe you can take a look in the database itself, see if there is some other value that these share but not the other completed mailings that aren't showing. (Also I see that the created by is blank on the couple shown in the screenshot - theoretically that should have nothing to do with it - but it's strange there's no contact listed maybe that's affecting things?)
Comments.UserDisplayName: RayWright
Tags: <civimail>
Title: Completed emails showing on draft list
ThreadText: # Completed emails showing on draft list
  
  (Asked by: username_0 on 2018-10-11)
  
  We've got 27 emails that show as completed, have a report, etc; however, they are showing on the list of Draft/Unscheduled emails. What could be causing this to happen? I'm trying to clean up the back-end for the new volunteers who will be working with the site this year, but I don't want to delete emails that have actually been sent.
  
  We're on Drupal 7 and CiviCRM 5.5.3
  
  [![CiviCRM screenshot](https://i.sstatic.net/iXIue.jpg)](https://i.sstatic.net/iXIue.jpg)
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_1**: Is this on CiviMail report or Activity report?  
  > **username_2**: If this is in CiviMail - what checkboxes are checked in the Mailing Status box for each menu item (Draft and Unscheduled Mailings vs. Scheduled and Sent Mailings)?  
  > **username_0**: It's the page you get when your select the Unscheduled and Draft link under the Mailings menu item.   The only thing checked is the one for unscheduled and drafts or whatever it's called (sorry, don't have it right in front of me at the moment). Only a couple dozen out of hundreds of sent emails are showing on that page.  
  > **username_0**: Now that I'm at the computer, I grabbed a screenshot to show where it's at and what is clicked.  
  > **username_2**: The screenshot is helpful - is see it's not respecting that 'draft / unscheduled' checkbox. Since it's only a couple dozen, maybe you can take a look in the database itself, see if there is some other value that these share but not the other completed mailings that aren't showing. (Also I see that the created by is blank on the couple shown in the screenshot - theoretically that should have nothing to do with it - but it's strange there's no contact listed maybe that's affecting things?)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-10-19. Score: 2
  
  I just verified that a completed mailing (in my test installation of 5.5.3) will show up in the draft/unscheduled list IF the original creator of the email is a deleted (permanently) user. Doesn't solve the problem but at least gives us a cause.
  
  > **Comments:**
  > **username_0**: Thanks! I wonder if I can go into the database and add a user to them. I've told folks not to remove people, just change their permission level.  
  > **username_2**: I didn't fully test it someone who was only partially deleted (still recoverable). Maybe there's a chance you can restore the original contact. If not, I agree you should just be able to assign it directly in the database to make that connection again and pull them off the report.  
  > **username_0**: I think they completely deleted the person, plus I'd have no idea who it was. I just assigned them all to my user account since it's easy to just input 1 as the user who did it. Now they're all gone from that list. :D  
  > **username_2**: Yay! Glad it all worked out!  
  
  ---
  
  