February 5, 2015 at 2:11 pm
Hello all. I am implementing a fax solution (Right Fax) and pulling email information from a table and passing into a variable. In order to send out a fax via email, the syntax is in the following example below:
Example:
To send a fax from Outlook to Jane Doe at 555-1212, enter:
[RFAX:Jane Doe@/FN=555-1212]
When the following syntax gets passed into the Send Mail Task, into the "To" line and the package is executed I'm receiving the following.
[Send Mail Task] Error: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".
[Send Mail Task] Warning: The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.
I realize it’s a malformed email address. Does anyone know of any work-around? Is it possible to create a group and instead of the fax syntax pass the group name? Or alias the name somehow? Any input is much appreciated.
February 5, 2015 at 2:40 pm
Thankfully, it's been over a decade since I set up a fax server, and it was a different product, whose name escapes me now. But back then, we had a "connector" set up at the Exchange server that would route the emails to the fax server when we used a 1234567890@faxproductname.com email address, where 1234567890 is the recipient's fax number. Is that an option on your end?
February 5, 2015 at 3:27 pm
Yes. It needs to be in the following syntax.
[FAX:Jane Doe@555-1212]
OR
[RFAX:Jane Doe@/FN=555-1212]
February 5, 2015 at 3:51 pm
When sending to the Send Mail task within SSIS, it's expecting a valid format email address. As this is a valid email address within our environment, is there any way to pass to Send Mail Task without failing?
February 6, 2015 at 6:01 am
Have you tried setting DelayValidation to False on the task?
February 6, 2015 at 6:28 am
yes. One of the first things I tried. Setting the delay did not do the trick.
February 6, 2015 at 6:32 am
i think the issue is connecting to an exchange server is not the same as connecting to an SMTP server, even if that server happen to be an exchange server.
the smtp interface, by definition, requires a formatted email address.
special things like Email groups / distribution lists and faxes, which do not have an smtp address, can be sent via the outlook client to the exchange server, but cannot be done via smtp, without the exchange administrator explicitly mapping the distribution list or fax target to an email address.
after that is set up, then just as [dlaughlin 24148], you can send to the special email address the exchange admin would set up, which confoirms to the number@destination.com format
Lowell
February 6, 2015 at 6:35 am
The error "The specified string is not in the form required for an e-mail address." is the exact same error you will get if you try to use the sp_send_dbmail procedure in msdb. Is your intention for SQL Server to send the email to the SMTP server? If so, I don't think it's going to allow it through in that format. I believe this check occurs before the SMTP server enters the picture.
A friend of mine doesn't use sp_send_dbmail to send email. He prefers to use CDOSYS instead. I don't know if this will work, as I haven't used it, but it's something else to try. There's an article on it at http://support.microsoft.com/kb/312839.
I find this problem very interesting, so if you do get this to work, please consider posting your solution.
February 6, 2015 at 6:54 pm
Thank you for the replies. I ended up using the RightFax .dll
The script task is getting pushed my input variables from my ForEach Loop container. This allows me to fax right out from the script task and not use my SMTP connection. I'm doing something very similar in C# as this post describes. http://stackoverflow.com/questions/988340/how-to-generate-a-fax-and-send-it-in-code
Hope this helps anyone who is attempting to automate a RightFax solution.
Continuing to test, test, test. So far so good.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply