ReplyMailManagementConfiguration
Defines configuration settings for Reply Mail Management (RMM) in Salesforce Marketing Cloud. RMM determines how reply emails are processed, routed, and categorized for an account. This table does not support deletions to preserve email routing integrity.
Table-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM ReplyMailManagementConfiguration WHERE Id = 123 SELECT * FROM ReplyMailManagementConfiguration WHERE Id IN (123, 456) SELECT * FROM ReplyMailManagementConfiguration WHERE CreatedDate > '2017/01/25'
Insert
You must specify the following fields when inserting to this table: EmailDisplayName and EmailReplyAddress.
INSERT INTO ReplyMailManagementConfiguration (EmailDisplayName, EmailReplyAddress) VALUES ('Test', '[email protected]')
Update
You must set a new value for EmailReplyAddress when executing an update against this table, and also supply its Id.
UPDATE ReplyMailManagementConfiguration SET EmailReplyAddress = '[email protected]' WHERE Id = 123
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Int | False |
The unique identifier (Id) of the reply mail management configuration. |
| Client_ID | Int | True |
The Id of the client that is associated with this reply mail management configuration. |
| EmailDisplayName | String | False |
Provides the display name that appears in the 'From' field when subscribers receive reply mail management messages. This value defines how the sending identity is presented in email clients. |
| ReplySubdomain | String | False |
Specifies the subdomain that the reply mail management configuration uses for routing inbound replies. This subdomain forms part of the reply-to address that manages inbound subscriber responses. |
| EmailReplyAddress | String | False |
Identifies the forwarding address to which inbound email replies are delivered after reply mail management processing evaluates unsubscribe requests, keywords, and filtering rules. |
| CreatedDate | Datetime | False |
Indicates the date and time when this reply mail management configuration was created. |
| ModifiedDate | Datetime | False |
Indicates the most recent date and time when this reply mail management configuration was modified by any system or user action. |
| DNSRedirectComplete | Bool | False |
Returns a value of 'true' when the reply-to subdomain's domain name system (DNS) records have been fully redirected to the Salesforce Marketing Cloud mail servers. It returns a value of 'false' when DNS routing has not yet been completed or verified. |
| DeleteAutoReplies | Bool | False |
Returns a value of 'true' when automatic replies (for example, out-of-office messages or auto-responders) are deleted instead of being forwarded to the configured reply address. It returns a value of 'false' when automatic replies are allowed to pass through to the forwarding mailbox. |
| SupportUnsubscribes | Bool | False |
Returns a value of 'true' when the reply mail management configuration processes unsubscribe requests that are submitted through inbound email replies. It returns a value of 'false' when unsubscribe handling is disabled and inbound requests must be managed through other workflows. |
| SupportUnsubKeyword | Bool | False |
Returns a value of 'true' when the configuration recognizes an unsubscribe keyword within an inbound email and applies the corresponding opt-out action. It returns a value of 'false' when unsubscribe-keyword recognition is disabled. |
| SupportUnsubscribeKeyword | Bool | False |
Returns a value of 'true' when the configuration recognizes the word 'unsubscribe' or a similar keyword within inbound email content and applies opt-out logic. It returns a value of 'false' when unsubscribe-keyword detection is not enabled. |
| SupportRemoveKeyword | Bool | False |
Returns a value of 'true' when the configuration supports a remove keyword that instructs the system to remove the subscriber from a mailing list. It returns a value of 'false' when remove-keyword actions are not processed. |
| SupportOptOutKeyword | Bool | False |
Returns a value of 'true' when the configuration recognizes an opt-out keyword and applies the related subscription removal rules. It returns a value of 'false' when opt-out keywords are not evaluated. |
| SupportLeaveKeyword | Bool | False |
Returns a value of 'true' when the configuration recognizes a leave keyword as an instruction to discontinue receiving messages. It returns a value of 'false' when leave-keyword support is not active. |
| SupportMisspelledKeywords | Bool | False |
Returns a value of 'true' when the configuration uses heuristic matching to interpret common misspellings of unsubscribe-related keywords. It returns a value of 'false' when only exact keyword matches are accepted. |
| SendAutoReplies | Bool | False |
Returns a value of 'true' when the reply mail management configuration automatically sends an acknowledgment message to the subscriber who replied. It returns a value of 'false' when no automatic acknowledgment email is sent. |
| AutoReplySubject | String | False |
Defines the subject line of the acknowledgment email that the system sends when automatic replies are enabled within this reply mail management configuration. |
| AutoReplyBody | String | False |
Contains the text or HTML body of the acknowledgment message that is delivered to subscribers when automatic replies are enabled. |
| ForwardingAddress | String | False |
Specifies the mailbox to which inbound subscriber replies are forwarded after reply mail management processing completes unsubscribe logic, keyword interpretation, and automated handling steps. |
| ConversationLifetimeDays | Int | False |
Indicates the number of calendar days that a reply mail management conversation remains active before the system considers it expired and eligible for closure. |
| ConversationLifetimeCycles | Int | False |
Indicates the number of reply cycles (message exchanges) permitted within an active conversation before the system expires the session and applies any associated expiration rules. |
| AnonymousRuleSet_ObjectID | String | True |
The system-controlled text string Id that identifies the rule set that is used to evaluate reply mail interactions when the sender identity cannot be matched or authenticated. |
| AnonymousRuleSet_Name | Int | True |
Provides the name of the rule set that governs processing for anonymous or unidentified reply mail flows. |
| AnonymousRuleSet_CustomerKey | String | True |
The user-supplied unique key that identifies the rule set that is used specifically for anonymous reply mail scenarios. |
| AnonymousAckTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to send acknowledgment messages for anonymous inbound replies. |
| AnonymousAckTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send definition responsible for acknowledgment messaging in anonymous conversation flows. |
| AnonymousAckTriggeredSend_Name | String | True |
Specifies the name that is assigned to the triggered send definition that generates acknowledgment messages in anonymous reply scenarios. |
| AnonymousAckTriggeredSend_TriggeredSendStatus | String | True |
Indicates the operational status of the triggered send definition used to acknowledge anonymous inbound replies. |
| AnonymousForwardTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to forward anonymous inbound replies to the configured forwarding address. |
| AnonymousForwardTriggeredSend_CustomerKey | String | True |
The user-supplied unique key that identifies the triggered send definition responsible for forwarding messages received from anonymous or unidentified senders. |
| AnonymousForwardTriggeredSend_Name | String | True |
Specifies the name assigned to the triggered send definition that forwards anonymous inbound replies. |
| AnonymousForwardTriggeredSend_TriggeredSendStatus | String | True |
Indicates the operational status of the triggered send definition that forwards messages received from anonymous senders. |
| ResponderConversationRuleSet_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the rule set responsible for handling reply mail conversations initiated by a responder rather than by the original message sender. |
| ResponderConversationRuleSet_Name | Int | True |
Specifies the name that is assigned to the rule set that governs how reply mail management processes conversation replies that originate from a responder rather than an initial sender. |
| ResponderConversationRuleSet_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the rule set used for responder-initiated conversation processing. |
| ResponderConversationAckTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to send acknowledgment messages to a responder. |
| ResponderConversationAckTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the acknowledgment triggered send associated with a responder conversation. |
| ResponderConversationAckTriggeredSend_Name | String | True |
Specifies the name assigned to the acknowledgment triggered send definition that responds to messages received from a responder. |
| ResponderConversationAckTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the acknowledgment triggered send that is used in responder conversations. |
| ResponderConversationForwardTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to forward responder messages. |
| ResponderConversationForwardTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send used to forward messages received from a responder. |
| ResponderConversationForwardTriggeredSend_Name | String | True |
Specifies the name that is assigned to the triggered send definition responsible for forwarding responder messages. |
| ResponderConversationForwardTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the triggered send definition that forwards responder replies. |
| InitiatorConversationRuleSet_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the rule set that processes conversations initiated by a subscriber. |
| InitiatorConversationRuleSet_Name | Int | True |
Specifies the name that is assigned to the rule set that governs the handling of conversation replies that originate from an initiating subscriber. |
| InitiatorConversationRuleSet_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the rule set used to process conversation flows started by a subscriber. |
| InitiatorConversationAckTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the acknowledgment triggered send for conversations initiated by a subscriber. |
| InitiatorConversationAckTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send definition used to send acknowledgment responses to initiating subscribers. |
| InitiatorConversationAckTriggeredSend_Name | String | True |
Specifies the name that is assigned to the triggered send definition that provides acknowledgment messaging for subscriber-initiated conversations. |
| InitiatorConversationAckTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the triggered send that provides acknowledgment messages for initiating subscribers. |
| InitiatorConversationForwardTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to forward subscriber-initiated conversations. |
| InitiatorConversationForwardTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send responsible for forwarding messages from an initiating subscriber. |
| InitiatorConversationForwardTriggeredSend_Name | String | True |
Specifies the name assigned to the triggered send definition that forwards messages within subscriber-initiated conversations. |
| InitiatorConversationForwardTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the triggered send that forwards subscriber-initiated conversation messages. |
| ConversationExpirationTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used to notify users when a conversation reaches the configured expiration point. |
| ConversationExpirationTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send used for conversation-expiration notifications. |
| ConversationExpirationTriggeredSend_Name | String | True |
Specifies the name that is assigned to the triggered send definition that handles conversation-expiration messaging. |
| ConversationExpirationTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the triggered send that processes messages related to conversation expiration. |
| MultiUseViolationTriggeredSend_ObjectID | String | True |
Specifies the system-controlled text string Id that identifies the triggered send definition used when the system detects a multi-use violation in reply mail processing. |
| MultiUseViolationTriggeredSend_CustomerKey | String | True |
Specifies the user-supplied unique key that identifies the triggered send that manages multi-use violation notifications. |
| MultiUseViolationTriggeredSend_Name | String | True |
Specifies the name that is assigned to the triggered send definition used for multi-use violation handling. |
| MultiUseViolationTriggeredSend_TriggeredSendStatus | String | True |
Indicates the current operational status of the triggered send definition that responds to multi-use violations. |
| InboundAddressIsOneUse | Bool | False |
Returns a value of 'true' when the inbound reply address is configured for single-use processing, meaning the address is intended for one conversation thread before expiration or rotation. It returns a value of 'false' when the inbound reply address supports multiple uses or ongoing conversation threads. |