Loading

Use a Spreadsheet Formula to Determine Your Salesforce Email-Sending Domains

Publiseringsdato: Oct 9, 2026
Beskrivelse

To send email from a domain, Salesforce requires verification via a DKIM key or a verified entry on the Authorized Email Domain list in Setup.

In Winter ’27, use the User Email Domains page in Setup to determine your email-sending domains. See Identify Your Email-Sending Domains.

Until your org is on Winter ’27, use email logs to see which domains your org has sent email from in the last 7 days. Then, to make sure that every sending domain is verified, cross-check the list against your DKIM keys and authorized email domains.

Løsning

This article explains how to use Salesforce email logs and a spreadsheet formula to determine your email-sending domains if your org is not yet on Winter ’27.

User Permissions Needed

To access email logs, you need the Modify All Data permission.

Steps to Determine Your Email-Sending Domains

  1. Request an email log for the last 7 days of outbound email. Then download the CSV file. To get a list of email-sending domains earlier than the last 7 days, run multiple email log reports and combine the results. Note: The download can take a few minutes.
  2. Open the CSV file in a spreadsheet editor, such as Google Sheets or Microsoft Excel.
  3. Identify the “Header From” column. The values are in the format Name <emailAddress>. For example, Joe Smith <joe.smith@example.com>`. By default, column Y contains this data.

In an empty column to the right of the data, add a formula to generate a list of unique email-sending domains. Construct a formula to get the string after the at symbol (`@`) from the “Header From” value and then remove duplicate values. Cross-check the list of email-sending domains against your DKIM keys and authorized email domains. See Get a List of Your Verified Email-Sending Domains.

Example Formulas for Google Sheets and Microsoft Excel 

The following two example formulas apply when the “Header From” value is in column Y and the data starts in row 2. Each formula extracts the text after the at symbol, removes the closing angle bracket, and returns the unique email-sending domains in the report data.

Google Sheets Formula 

`=UNIQUE(FILTER(ARRAYFORMULA(TRIM(SUBSTITUTE(REGEXEXTRACT(Y2:Y, "[^@]+$"), ">", ""))), REGEXMATCH(Y2:Y, "@")))`

Microsoft Excel Formula 

`=UNIQUE(FILTER(TRIM(SUBSTITUTE(TEXTAFTER(Y2:Y100000,"@",-1),">","")),ISNUMBER(SEARCH("@",Y2:Y100000))*(Y2:Y100000<>"")))`

Knowledge-artikkelnummer

005459598

 
Laster
Salesforce Help | Article