xp_send mail task fails

  • I made a copy of an existing working dts package and changed the name of the server were a file is copied from and the server name that the file is copied to.  The original package was owned by the dba.  The new copy is owned by me (not a dba).  The copy succeeds but the xp_send mail task fails with the following error: "Error sending mail: MAPI error: One or more of the recipients specified are ambiguous."  The recipient is an Outlook email distribution list, which is the same as in the working package.  Help!

  • When I ran into that error, it was because xp_sendmail was looking for an AD logon id and not the e-mail user name.  Same person might have slightly different entries for the two if there are other people with the same name.

  • Make sure the recipient that you are supplying is recognised by outlook for definite.

    Cut and paste the actual recipient string into outlook and click check names. Outlook doesn't recognise a name for a lot of reasons. E.g if you had an email address called Davis, Paul and another called, Davis Paula, it would not recognise either.

    To proce the recipient is causing the error, send an email to an extral email address. If that doesn't work you can rule it out.


    ------------------------------
    The Users are always right - when I'm not wrong!

  • Thank you Jonathan.  Your suggestion worked.  Using the recipients actual email address david.taylor@bestsoftware.com rather than selecting Taylor, David from the address book did the trick.

  • Glad to have helped. Outlook is so annoying when trying to resolve names. I have never found a way around other than the full mail address.


    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply