Jim Dettman
jimdettman at earthlink.net
Fri Jun 16 07:30:32 CDT 2006
Darren, You have to ensure that your using tripledee.com.au's network to reach them. "relaying" mail indicates that they consider you coming from an outside system. As a result, they won't relay the mail. Most ISP's don't. There are very few ISP's that have open relay's and usually when they do, they have some type of message limit on the account. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK Sent: Friday, June 16, 2006 1:53 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2203: relaying mail to someserver.com.au is not allowed Hi All I am using some code I poached from this list (From Marty Connelly - actually) to send email via CDO (Code below) I am puzzled though - It is for a mail out of about 20 or 30 pdf files Not enough to trigger an email spam response I would have thought from the host mail server - Anyway... I send a whole swag of test ones using the real persons firstname at tripledee.com.au (I have a catch all for email to tripledee so I get 'em all) Cool - it worked wonderfully well and I did get 'em all with the sequential attachments - excellent - very excited I hade the code looping through a recordset of 27 records and had it putting the !FirstName and the !EmailAddress into the necessary fields - looping beautifully - excellent - but that's it - One recordset loop only it seems - it now refuses to work again - though I have made it work once (since) only sending a single email as per the code below but now it continues to fail the error I am getting is... Err.Number = -2147220977 Err.Description = The server rejected one or more recipient addresses. The server response was: 550 relaying mail to tripledee.com.au is not allowed But I did send 27 of 'em with attachments to tripledee.com.au this morning? - What gives? So...Any suggestions? Many thanks in advance Darren ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sub SendCDO() ' This example use late binding of CDOSys, you don't have to set a Reference ' You must be online to net when you run the sub ' You must be running WinXP or Win2000 Dim cdoMessage As Object Dim objCDOMail As Object Dim strschema As String On Error GoTo ErrorHandler ' Enable error-handling routine. Set cdoMessage = CreateObject("CDO.Message") Set objCDOMail = CreateObject("CDO.Configuration") strschema = "http://schemas.microsoft.com/cdo/configuration/" objCDOMail.Load -1 DoCmd.Hourglass True With objCDOMail.Fields .Item(strschema & "sendusing") = 2 .Item(strschema & "smtpserver") = "mail.bigpond.com" .Item(strschema & "smtpserverport") = 25 .Update End With With cdoMessage Set .Configuration = objCDOMail .to = d.dick at tripledee.com.au .From = "Some Dude <SomeWayCoolDude at someCoolServer.com> .CC = "" .BCC = "" .Subject = "Testing testing 1...2...3..." .TextBody = "Is Anybody there? Hello Hello...." .AddAttachment "C:\10009.pdf" .send End With DoCmd.Hourglass False Set cdoMessage = Nothing Set objCDOMail = Nothing Exit Sub ErrorHandler: DoCmd.Hourglass False Debug.Print Err.Number & "-" & Err.Description Set cdoMessage = Nothing Set objCDOMail = Nothing Exit Sub End Sub -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com