File Details on MailList.dbf and MailList.txt

Top  Previous Topic  Next Topic

 

The Mailing List function (select OTHER 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

City, Character Field, Length 16

State or Province, Character Field, Length 2

Zip_Code, Character Field, Length 7

Zip_Ext,* Character Field, Length 4

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 AnyBook.  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:

Vendor Name

Address1

Address2

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.