Hi all,

When i was trying send excel sheet to users i got one error that is:

The message could not be sent because one of the recipients was rejected by the server. The rejected e-mail address was 'lmcginn@ems.atttt.com'. Subject 'SLA-MNS-0410607-051507',Account: 'smtp.ems.att.com', Protocol: SMTP, Server Response: '553 5.5.4 <lmcginn@ems.atttt.com>... Host ems.atttt.com unresolveable', Port: 25, Secure(SSL): No, Server Error: 553, Error Number: 0x800CCC79

Code:
DoCmd.SendObject acSendQuery, "SLA-MNS", acFormatXLS, "lmcginn@ems.atttt.com", "aprillowens@atttt.com", "alanRobinson@ems.atttt.com", "SLA-MNS - " & Format(Forms!Main!FromDate.Value, "mmddyy") & "-" & Format(Forms!Main!ToDate.Value, "mmddyy"), "See Attached File. Please refer all questions to rajkhurana@ems.atttt.com ", False

What's wrong with this code.
Anyone can help me it would be very helpful to me

Thanks,
Bhaskar

'lmcginn@ems.atttt.com' rejected by 'smtp.ems.att.com' ...

too many t's in the address ...?

'lmcginn@ems.att.com'

It's definitely not a problem with your code. The email on their side does not recognize that username:

"<lmcginn@ems.atttt.com>... Host ems.atttt.com unresolveable"

What that line is telling is that the email server at ems.atttt.com cannot resolve the name "lmcginn" and therefore cannot deliver the email. Get the correct email address and try again.