Bhaskara123
Registered User.
- Local time
- Today, 05:14
- Joined
- Mar 26, 2007
- Messages
- 11
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
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