EmailAddress: Value cannot be empty

EmailAddress: Value cannot be empty

When importing a file into Delivra, you might see an error indicating that some cells in the Email Address column are blank—even though they don't appear empty to you. This error typically means that the system has detected formatting in those cells, but no actual email addresses.

This issue does not mean your entire file is invalid or that the import has failed. It simply flags that there are empty or improperly formatted cells within the Email Address column.

What causes this error?

Excel and other spreadsheet tools can retain invisible formatting in cells that appear empty. If a cell has been formatted (e.g., font style, borders, or background color) but doesn’t contain an email address, Delivra will flag it during import.

How to resolve or avoid the error

To clean up your file and avoid this warning, try one of these approaches:

  1. Reset the "last cell" in your worksheet

    • Scroll to the last row and column that actually contains data.

    • Clear formatting in all blank rows and columns between your data and the Excel-defined last cell.

    • Save your file as a .CSV before reimporting.

  2. Copy your actual data into a clean worksheet

    • Highlight and copy only the cells with valid contact data.

    • Paste into a new, blank worksheet.

    • Save the new file as a .CSV and import it into Delivra.

Best practices for importing files

  • Always save your file in .CSV format before importing.

  • Double-check that the Email Address column contains valid addresses only—no empty cells or stray formatting.

  • Avoid hidden characters or formulas in email address fields.

Still running into issues?

If you've cleaned your file and still receive errors, try opening the file in a plain-text editor like Notepad to look for hidden characters. Or, reach out to our support team at support@delivra.com.

    • Related Articles

    • Empty Segment Error or Mailing Sent to 0 Contacts

      Seeing an “Empty Segment” error when testing or sending an email campaign—especially when you know your segment contains contacts—can be frustrating. This guide walks you through common causes and how to troubleshoot the issue. What Causes an “Empty ...

    • Create segments that evaluate date information

      Using our robust segmentation tools, you can build a variety of segments that evaluate date fields in multiple ways. Below we outline popular date segments. Tip: Open images in a new browser tab for a larger view. How-To Example 1: Find contacts with ...

    • Creating Segment of Contacts

      What is a segment? A segment is a dynamic subset of your contacts database. Segments use clauses to determine recipients of a campaign based on evaluation of data values stored on your contact records or behavior of recipients of a sent email. You ...

    • Auditing Changes to Contact

      The Contact Audit Log is a helpful tool for administrators to track changes made to individual contact records. Whether updates come from internal teams or integrated systems, the audit log provides visibility into when and how a contact’s data was ...

    • How do I import a list of unsubscribed contacts to my account?

      If you have previously used an email service provider like Delivra, we recommend that you migrate any email subscribers that opted-out of campaigns you sent through that system. This way, you're ensuring that you don't all of a sudden start emailing ...