Maxa Help

Keywords:
Previous Item | Next Item | All | Return
Next CUSTOMER LIST | All CUSTOMER LIST
MAXA - Online Help -

Item Photo Description
40  Can a MAXA customer list be exported?

Yes! MAXA data can be exported in a format that can be viewed by spreadsheets, databases, and word processors. To export name data, a format file must first be created.

In this example we are going to export the information needed to print mailing labels. Follow the steps below to create a format file...

  • Customer list
  • File
  • Export
  • Create a new format file
  • SAMPLE
A blank page will appear. On it we are going to place codes that will be replaced with actual data when the export is selected. Add the following line to the blank page. Press 'Escape' when you are finished...

~b^~c^~d^~e^~f^~g^~h

The '~' character followed by a letter will be replaced by the name information. In this format file the codes will be replaced as follows...

  • ~b = last name
  • ~c = first name
  • ~d = company
  • ~e = address
  • ~f = city
  • ~g = state
  • ~h = zip
The CODES section of the help files lists a complete chart of all the applicable codes. The '^' character between the '~?' letters will be replaced with a tab character. The tab will be interpreted as the delimeter when the information is imported by other programs.

The format file only needs to be created one time. Once created it can be accessed by using the following commands...

  • Customer list
  • File
  • Export
  • Select export format
  • SAMPLE
Once the format has been selected select...
  • Start exporting
  • Select export location: Current (C:\maxa\export) or Drive A:
  • Enter a filename
The output can now be viewed by a variety of other programs.

Refer to the help files of the spreadsheet or database programs for more information on how to import the text file.