Resolve "Error database \path\filename.xls could not be opened" when attaching a mail list to Envelope Designer

print
Product affected: Envelope Designer
 

Issue

When attaching a mail list to Envelope Designer, the error "Error database \path\filename.xls could not be opened" is displayed, where \path\filename.xls is the path and file name of the mail list, such as "Error database Y:\MyFolder\mymaillist.xls could not be opened".

Cause

The header formats of the import file are incorrect.

Resolution

  1. Close Envelope Designer.
  2. Navigate to the file you are trying to attach and open it with the default program associated with it (for example, if it is a .xls file, open it in Excel).
  3. Look at the headers (name, address, city, state, etc.) and tabs (Excel files will show tabs at the bottom for each sheet) of the file. Make sure that the headers and tabs meet the following guidelines:
    • The header cannot be longer than 10 characters.
    • The header name cannot contain spaces.
    • The header name cannot contain special characters.
  4. Open Envelope Designer and attach the file. If the error is still displayed, proceed to the next step.
  5. Envelope Designer can have issues accessing a file if the file path is too long. If the path to the file is longer than 65 characters (the entire path, such as Y:\Folder\AnotherFolder\MyFolder\mymaillist.xls), copy the file to the root of the C:\ drive, then open Envelope Designer and attach the file again.
If the issue is still not resolved, contact software support.

UPDATED: April 04, 2017