mail stuck in drop folder and report generation

Question

There is an email stuck in the drop box on SharePoint App server, that is headed for payupload@X .yy.zz.com we have seen instances where we had to “reset” the email setup for a library to be able to receive emails. We just solved that issue on another library and that is how we found this email. Not sure how long these stay in the Drop box either before they just go away. This one has been there about 4 hours now.

I wanted to test this same mail id in another library but as we know each library is unique with email address.
I could send email to above mail id using outlook.

and we are not able to find above mail address associated with which library? but above mail id is resides in one of the incoming library settings. Please let me know how to find out which library it is?

What we can do to fix this?

2nd requirement is:
since we are migrating 2010 to 2016 using DB method, as a proactive action , Is there a way we could generate a report per site collection to provide to the SCAs before upgrade that tells them any libraries/lists they have set up to receive email? Just another way to be helpful and prevent issues.

Answer 1

Hi @sns ,

To narrow down your issue, let’s verify the followings:

1. As you migrated from SharePoint 2010 to 2016, have you configured incoming email in SharePoint 2016?
2. Please go to Central Administration -> System Settings -> Configure incoming e-mail settings and provide your settings like the below:
   
3. Please run IIS 6.0 Manager -> SMTP Virtual Server -> Domains -> Properties:
   
   Check whether Drop directory has been set correctly:
   
4. Please check if “Microsoft SharePoint Foundation Incoming E-Mail” has been started on your server:
   
5. Please check SMTP Service is running on your SharePoint server and its startup type is set to automatic:
   
6. Find the timer job “Microsoft SharePoint Foundation Incoming E-Mail” and click “run now” to run the timer job immediately.
7. Go to job history and check if timer job “Microsoft SharePoint Foundation Incoming E-Mail” ran successfully:
8. If this issue still exists, please check your ULS Logs to find whether there are useful information in it.

For your second requirement, please run the following PowerShell command as administrator in your environment:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue  
  
#Web Application URL   
$WebAppURL="http://<webApplication URL> "  
$Report="c:\IncomingEmails.csv"  
  
# Enumerate all lists in the web application  
Get-SPWebApplication $WebAppURL | Get-SPSite -limit ALL | Get-SPWeb -Limit ALL | ForEach-Object {  
#Get the Current Site  
$Site = $_  
#Get all Lists with Incoming Email enabled  
$Site.Lists | Where-Object { ($_.CanReceiveEmail) -and ($_.EmailAlias) }| ForEach-Object {  
      New-Object -TypeName PSObject -Property @{  
              ListName = $_.Title  
              SiteUrl = $Site.Url  
              Email = $_.EmailAlias }  
   }  
} | Export-CSV $Report -NoTypeInformation  
  
Write-host "Incoming Emails Report Generated!"      

Note: remember to replace variable “$WebAppURL” and “$Report” with your own. Variable “$Report” is the path you want to store the report file and you need to create the report file before running the PowerShell command.

You will get a report like below:

I hope this information has been useful, please let me know if you still need assistance.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.