Skip to content

PREFEXP

Export a set of Name record data with their Preferred Address (as set in Mail Pref field), to an external file in specified format.

Reporting Area(s)

Names

Required Parameters

None

Optional Parameters

  1. Drive\Directory\File name for export file (i.e.: "c:\acehold\exprec"). Default is c:\nameout.dbf
  2. Character expression: field to add to export (i.e. 'rgcrse as CourseNo')
  3. Logical .t. exports firm contact (fmcontact)

Example(s)

JUSTAFTER('=PREFEXP()') - exports name and address to a dBASE III file in c:\nameout.dbf

JUSTAFTER('=PREFEXP("c:\acehold\myfile.xls")') - exports name and address to a Microsoft Excel file in c:\acehold, called MYFILE.xls

Notes

Fields included are: Name1, MI, Name3, Title, Firm, Address, Address2, City, State, Zip, Country, Email.

If you pass the file name within parameter # 1 with the .xls extension, the function will generate a Microsoft Excel file or pass the file name within parameter # 1 with the .TXT or .CSV extension, the function will generate an ASCII output file.

COPY2XLS
MEMOEXP
NAMEEXP