GENERAL RULES AND REQUIREMENTS

1. An Excel document with exact format and requirements as defined below must be created.
2. In Excel Sheets, the Required fields that are defined as text must contain at least one valid non-digit character. Valid characters are: printable characters such as: {A-Z, a-z} Alpha-characters, - (Dash), _ (Underscore), # (pond sign), " (only one double-quote sign),
   if you enter some large numbers (integers, decimals) without any other character in a text field, Excel treats and show them as null "" and will cause the program to fail.
   Our text fields that need values to be input by admin here are:  email_address, Therefore, we are requiring a valid email address to be entered in the email_address field in the Excel sheet. If these requirements are not met, when we import the excel, it causes un-desirable results in our database.
3. Even if a cell (or columns) is saved with text format but if it has only numbers (integers, decimals, etc)  it reads, treats and show them as null "".  it causes the program to fail. This is against MS EXCEL definition that stays a number in a text cell shows as it appears (e.g., integer).
   What should be done?  Insert at least one character in the field such as {A-Z, a-z} Alpha-characters, - (Dash), _ (Underscore), # (pond sign), " (only one double-quote sign), etc.
4. No other special characters (e.g.,  : (colon) ;(semi-colon)  '(single quote)) or non-printable characters (e.g., control key followed by character J which sounds the bell, etc) should be used in any field. These character may make the systems to interpret them as directories, blocks, non-closing quote, etc and causing problems.
   Suggestion: use only digits {0-9}, Alpha-Characters {A-Z, a-z}, valid special characters for email such as:  _ (under-score), - (dash), @ (at sign). No space is allowed.
5. When saving the desired Excel document, all fields (rows and columns) that are going to be used for the email database must be highlighted and saved with "emails" under "Defined Name" OR "Cell Name" OR "Name Box". The name of the excel document could be anything you want and should reside in your computer.
   If you have question on how to save a collection of data (rows and columns) with an specific "defined name" see below or contact Texas Five Star Realty.

1. Select the cell(s).
   Remember, for your email list, the active cells must cover (highlighted) all rows and columns in your excel file.  
2. Click in the Name box, which is at the left end of the formula bar. (It's where the active cell's row and column reference normally appear.)
3. Type the name you want to use for the range, as shown in Figure 1-1, and press Enter. In Figure 1-1, cell C5 is named profit.
   Remember, for your email list, the name box must be typed as "emails" with no double quotes.
   Otherwise, creating the database will fail.

Figure 1-1: Name a range by typing text in the Name box.
Named ranges are absolute references by default. A reference to the range does not change when you copy it to another cell.
 

To change a name, or delete one:

1. Select Insert > Name > Define OR press Control key followed by F3 key.
   The Define Name dialog box appears, as shown in Figure 1-2.