Answers
Subject Date - DESC Rating Viewed Topic
Email not received by iService 1/16/2014 9:28:58 AM 4.0 2789 Email Processing
Article Selected >> Changing the mailbox specified for messages in SMTPout
Question:
I have messages sent via iService, but the mailbox they used is unavailable. As a result, the messages are going to retry and fail to be delivered. How can I change the mailbox that it will use after it has been marked as sent?
Answer:
Messages in the SMTPout table have a mailboxID that specifies the mail server to which they will be sent. You can run a SQL script to update this as follows.

Syntax:
update SmtpOut set mailboxID = NewMailboxID, timeSent = NULL where isSent = 0 and mailboxID = OldMailboxID

Example:
update SmtpOut set mailboxID = 22, timeSent = NULL where isSent = 0 and mailboxID = 1

In the example above, all messages that are not yet sent (isSent=0) that have a mailboxID of 1 will be changed to use mailboxID 22 instead.
Article DetailsSubscribe and Rate this article
Article ID:220542
Date Updated:9/5/2013 10:53:53 AM
# Views:3015
Article Creator:Scott Whitsitt
Article Topic:Email Processing
Attachments:-- None --
Setting message in SMTPOut for immediate delivery 2/25/2013 1:27:09 PM None 3632 Email Processing
Forward Email to External Email Address - Exchange 2003 2/7/2011 4:03:12 PM None 2304 Email Processing
Testing your SMTP connection 12/10/2010 4:43:56 PM 4.0 2299 Email Processing
Setting pending messages as Sent within iService 9/7/2010 1:17:41 PM None 2402 Email Processing
Message received with a blank body 7/27/2010 3:27:17 PM 5.0 2165 Email Processing
Techniques for minimizing bounced emails 7/1/2010 9:55:45 PM 5.0 2522 Email Processing
Capturing the bounce reason from undeliverable messages 7/1/2010 5:06:59 PM None 2204 Email Processing
Options for the From email address 5/26/2010 12:38:19 PM None 2135 Email Processing
Email not leaving iService 5/19/2010 8:11:26 AM None 2065 Email Processing
Please Wait...