The Mailing List Module (which is reached by selecting MAIN TASKS and MAILING LIST from the Menu Bar) creates two files (MailList.dbf and MailList.txt).  If your software program needs details on the structure of the files, the following may be helpful:

MailList.dbf

MailList.dbf is a dBase file consisting of the following 8 fields:

Bill_Name, Character Field, Length 33

Address1, Character Field, Length 33

Address2, Character Field, Length 33

Address3, Character Filed, Length 40  (Only included if you have Extra Address turned on)

City, Character Field, Length 16

State or Province, Character Field, Length 2

Zip_Code, Character Field, Length 7

Zip_Ext, Character Field, Length 3 *

Country, Character Field, Length 20

Email Address, Character Field, Length 35 (Only included if "Include Email Address in Exported Files" is checked in the Mailing List Module)

* Note that Zip_Ext is no longer used, rather the Zip_Code field holds both the zip code and the extension.  We have retained Zip_Ext in the export file to retain compatibility with previous versions of AnyOrder.  When you create labels in a word processing or label program, just disregard the field.

MailList.txt

MailList.txt is delimited file, consisting of 8 fields.  Each field is delimited with double quotes (") and separated by commas.  Each record is separated by a carriage return.  The fields are in the following order:

Billing Name

Address1

Address2

Address3 (Only included if you have Extra Address turned on)

City

State or Province

Zip Code

Zip Ext *

Country

Email Address (Only included if "Include Email Address in Exported Files" is checked in the Mailing List Module)

* Zip Ext no longer used.  See note above.

Creating a Different Set of Fields

Some uses of the mailing list files may require more flexibility in the fields that make up MailList.dbf and MailList.txt.  For example, if you are importing the mailing files into a newsletter application on a website, you may need to import the fields in a certain order, and you may need additional fields not found in MailList.dbf or MailList.txt.

To change the order of fields or add fields, use AnyOrder's Export module.  In the Export module, you can design a profile which has exactly the kind of structure required.  After creating the profile, return to the first dialog of the Export series, and under "Select Invoices to be Exported" select the following option: "Use a Combination of a Selection List and Filter." When you start the export, the Mailing List module will appear, and you'll have access to all of the mailing list features with the added advantage of being able to create an export file made up of your selection of fields.