top of page

Data Migration Guide — Email Scrubber Archive Object

Object: EmailScrubber__Redundant_EmailMessage_History__c

The Email Scrubber Archive object (EmailScrubber__Redundant_EmailMessage_History__c) is designed to store historical email data in a lightweight, storage‑efficient format while preserving the metadata required for compliance, searchability, and case continuity.

​

In a standard Email Scrubber implementation, the typical approach is to run the Email Message Archive batch process. This process automatically identifies eligible EmailMessage records and archives them into the archive object. If this is your approach, you may skip this page.

​

However, if you are executing a data migration and want to be more strategic with your historical email load, you may want to consider loading directly into the archive object instead of importing all historical EmailMessage records.

​

This approach allows you to:

​

  • Reduce storage consumption on Day 1

  • Simplify your active data load by only importing recent or business‑critical email threads

  • Avoid bringing unnecessary historical email bloat into the EmailMessage table

  • Maintain a complete audit trail without inflating your primary email storage

​

This page outlines how to migrate existing EmailMessage records—or external email data—into the archive object using the same field‑mapping framework that powers the automated archiving process.

​

This guide is intended for Salesforce Admins, Architects, and Data Migration teams performing:

​

  • Org consolidations

  • Legacy email ingestion

  • Pre‑migration pruning

  • Storage remediation projects

  • Historical data normalization

​

Understanding the Archive Object Structure

Object​

Archiving email messages requires populating a single object: EmailScrubber__Redundant_EmailMessage_History__c.

 

This object is the storage‑efficient archive equivalent of the standard EmailMessage object and is the sole destination for all historical email data during migration.

Field Mapping

The fields fall into 3 distinct categories; standard EmailMessage field mirrors, metadata/search fields, and relationship fields.

Field Label:
Required:

BCC Address

API Name:

TRUE

Type:

EmailScrubber__BCC_Address__c

Long Text Area(4000)

Notes:

Mirrors EmailMessage.BCCAddress

Field Label:
Required:

CC Address

API Name:

TRUE

Type:

EmailScrubber__CC_Address__c

Long Text Area(4000)

Notes:

Mirrors EmailMessage.CCAddress

Field Label:
Required:

First Opened Date

API Name:

FALSE

Type:

EmailScrubber__First_Opened_Date__c

Date/Time

Notes:

Mirrors EmailMessage.FirstOpenedDate

Field Label:
Required:

From Address

API Name:

TRUE

Type:

EmailScrubber__From_Address__c

Email

Notes:

Mirrors EmailMessage.FromAddress

Field Label:
Required:

From Name

API Name:

TRUE

Type:

EmailScrubber__From_Name__c

Long Text Area(1000)

Notes:

Mirrors EmailMessage.FromName

Field Label:
Required:

HTMLBody

API Name:

TRUE

Type:

EmailScrubber__HTMLBody__c

Rich Text Area(131072)

Notes:

Mirrors EmailMessage.HTMLBody

Field Label:
Required:

HTMLBody Text

API Name:

FALSE

Type:

EmailScrubber__HTMLBody_Text__c

Long Text Area(131072)

Notes:

Mirrors EmailMessage.HTMLBody

Field Label:
Required:

Headers

API Name:

TRUE

Type:

EmailScrubber__Headers__c

Long Text Area(32000)

Notes:

Mirrors EmailMessage.Headers

Field Label:
Required:

Is Externally Visible

API Name:

FALSE

Type:

EmailScrubber__Is_Externally_Visible__c

Checkbox

Notes:

Mirrors EmailMessage.IsExternallyVisible

Field Label:
Required:

Is Incoming

API Name:

TRUE

Type:

EmailScrubber__Is_Incoming__c

Checkbox

Notes:

Mirrors EmailMessage.IsIncoming

Field Label:
Required:

Message Date

API Name:

TRUE

Type:

EmailScrubber__Message_Date__c

Date/Time

Notes:

Mirrors EmailMessage.MessageDate

Field Label:
Required:

Message Identifer

API Name:

TRUE

Type:

EmailScrubber__Message_Identifer__c

Long Text Area(1000)

Notes:

Mirrors EmailMessage.MessageIdentifer

Field Label:
Required:

Original Created By Id

API Name:

TRUE

Type:

EmailScrubber__Original_Created_By_Id__c

Lookup(User)

Notes:

Mirrors EmailMessage.CreatedById

Field Label:
Required:

Original Created Date

API Name:

TRUE

Type:

EmailScrubber__Original_Created_Date__c

Date/Time

Notes:

Mirrors EmailMessage.CreatedDate

Field Label:
Required:

Original Email Message Id

API Name:

TRUE

Type:

EmailScrubber__Original_Email_Message_Id__c

Text(18)

Notes:

Source Sytem Identifier. If migrating from another Salesforce instance, set to the original EmailMessage.Id.

Field Label:
Required:

Original Message Size

API Name:

FALSE

Type:

EmailScrubber__Original_Message_Size__c

Number(18,0)

Notes:

If available, populate the original Email Message footprint in bytes. If not knows, set to 0.

Field Label:
Required:

Owner

API Name:

FALSE

Type:

OwnerId

Lookup(User)

Notes:

Mirrors EmailMessage.OwnerId

Field Label:
Required:

Parent Case

API Name:

FALSE

Type:

EmailScrubber__Parent_Case__c

Lookup(Case)

Notes:

Mirrors EmailMessage.ParentId. Required for correct LWC but can be left blankf original case is not being migrated.

Field Label:
Required:

RelatedTo Type

API Name:

FALSE

Type:

EmailScrubber__RelatedTo_Type__c

Text(150)

Notes:

If RelatedToId is popuated, populate field with the Object Type Name.

Field Label:
Required:

RelatedToId

API Name:

FALSE

Type:

EmailScrubber__RelatedToId__c

Text(18)

Notes:

Mirrors EmailMessage.RelatedToId. Required when RelatedToId is enabled in the instance.

Field Label:
Required:

Status

API Name:

FALSE

Type:

EmailScrubber__Status__c

Text(30)

Notes:

Mirrors EmailMessage.Status

Field Label:
Required:

Subject

API Name:

TRUE

Type:

EmailScrubber__Subject__c

Long Text Area(3000)

Notes:

Mirrors EmailMessage.Subject

Field Label:
Required:

Subject_Search

API Name:

FALSE

Type:

EmailScrubber__Subject_Search__c

Text Area(255)

Notes:

Used as a part of the Admin Email Search LWC. Populate with first 255 characters of Subject.

Field Label:
Required:

Text Body

API Name:

TRUE

Type:

EmailScrubber__Text_Body__c

Long Text Area(131072)

Notes:

Mirrors EmailMessage.TextBody

Field Label:
Required:

To Address

API Name:

TRUE

Type:

EmailScrubber__To_Address__c

Long Text Area(4000)

Notes:

Mirrors EmailMessage.ToAddress

Field Label:
Required:

To Address Search

API Name:

TRUE

Type:

EmailScrubber__To_Address_Search__c

Text Area(255)

Notes:

Used as a part of the Admin Email Search LWC. Populate with first 255 characters of To Address.

Field Label:
Required:

Validated From Address

API Name:

FALSE

Type:

EmailScrubber__Validated_From_Address__c

Text(200)

Notes:

Mirrors EmailMessage.ValidatedToAddress

bottom of page