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 ...
    • Changing the Status of Contacts

      Sometimes, contacts need to be resubscribed due to an accidental unsubscribe or removed due to lack of engagement. In Delivra, you can change the status of contacts either manually or in bulk via an import: Manually Changing Contact Status You can ...
    • Linking Email and SMS Contacts

      When managing SMS and email subscribers in Delivra, it's helpful to know whether a contact’s email and mobile number are linked within your account. This connection determines how easily you can manage, segment, and communicate with contacts across ...
    • Import your contact list

      Importing contacts into Delivra is a straightforward process, but a little prep work goes a long way. By organizing your data ahead of time, you’ll ensure a smooth experience and help your campaigns take flight faster. File Preparation Tips Before ...
    • How do I find a contact in my account?

      DESCRIPTION: Contact details are located in the Contacts dashboard. There are two search options - keyword search and Find Contacts search. HOW-TO: Use keyword search- Go to Contacts dashboard Enter a full or partial email address or name value in ...