0
I have an automated SQL task that sends an email using SMTP, to an Outlook group with 36 recipients. Most of the people get the email and can reply to it with no problem. Some do not get it. Testing has showed the common theme to be the email arrives with no FROM address, so it fails some 'bounce back' test and never gets into the network.
Anyone seen such a thing, or is this more likely to be happening in the SQL server?
BattlFrog
Posted 2016-03-18T20:59:46.393
Reputation: 273
Whatever (php?) statement is sending the mail needs to include the "from" header, it's not really standard. That's only the first and easiest problem to resolve tho-- there may be other issues with mail headers. – Tyson – 2016-03-19T02:22:57.730
The email is created by an SSIS package and there is an valid email address in the FROM space. – BattlFrog – 2016-03-20T16:00:13.880
You should contact Microsoft support services about SSIS generating emails that appear not to have a "from" header. Like I said tho, "from" from the SMTP server point of view is not really a standard required header, except it is because mail without it will be targeted as spam somewhere along the way. It's possible that the SSIS package thinks it's talking to an Exchange server via SMTP, Exchange in most configs will add a FROM header based on the account used to authenticate. Anyway the first problem you're facing is email headers missing "from", likely an SSIS configuration issue. – Tyson – 2016-03-20T16:34:22.813