J
jimt
I'm using Access-2000. I have a customer table containing their email
address. I have a form with an event button to run a form subroutine to email
the selected customers with specific information about their accounts. A Do
Loop is used t cycle through the table, build a subject line and message
body. All this works fine.
The sendobject line is:
DoCmd.SendObject acSendNoObject, acFormatTXT, , email_addr, , ,
subject_line, msg_body, False
The sendobject opens an Outlook Express window and immediately emails the
message, closes the Outlook Express window, and repeats the process for all
the selected customer.
EXCEPT... if there is an invalid email address. The Outlook Express window
displays the following error message:
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'tinder (e-mail address removed)'.
Subject 'test',
Account: 'pop3.fairpoint.net', Server: 'smtpauth.fairpoint.net', Protocol:
SMTP, Server Response: '501 5.1.3 Bad recipient address syntax', Port: 25,
Secure(SSL): No, Server Error: 501, Error Number: 0x800CCC79
(note the address was created as an invalid test to replicate the problem)
The error message requires the user to click on OK before continuing on to
the next record. Is there a way to:
1. automate the response to/bypass the error
2. elimated the opening and closing the Outlook Express window. (we
sometimes have 300-400 email to send in one run so the open-close takes extra
time)
Thank
Jim T.
address. I have a form with an event button to run a form subroutine to email
the selected customers with specific information about their accounts. A Do
Loop is used t cycle through the table, build a subject line and message
body. All this works fine.
The sendobject line is:
DoCmd.SendObject acSendNoObject, acFormatTXT, , email_addr, , ,
subject_line, msg_body, False
The sendobject opens an Outlook Express window and immediately emails the
message, closes the Outlook Express window, and repeats the process for all
the selected customer.
EXCEPT... if there is an invalid email address. The Outlook Express window
displays the following error message:
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'tinder (e-mail address removed)'.
Subject 'test',
Account: 'pop3.fairpoint.net', Server: 'smtpauth.fairpoint.net', Protocol:
SMTP, Server Response: '501 5.1.3 Bad recipient address syntax', Port: 25,
Secure(SSL): No, Server Error: 501, Error Number: 0x800CCC79
(note the address was created as an invalid test to replicate the problem)
The error message requires the user to click on OK before continuing on to
the next record. Is there a way to:
1. automate the response to/bypass the error
2. elimated the opening and closing the Outlook Express window. (we
sometimes have 300-400 email to send in one run so the open-close takes extra
time)
Thank
Jim T.