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 ​
- Drive\Directory\File name for export file (i.e.: "c:\acehold\exprec"). Default is c:\nameout.dbf
- Character expression: field to add to export (i.e. 'rgcrse as CourseNo')
- 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.