Mailing List Database Format
The preferred file format for a mailing list submission to HOTGLOSS Printing is a comma(*.CSV) or tab(*.txt) delimited text file. We can also accept a native Microsoft Excel file.
The names of possible fields are listed below for your information.
The possible database fields are not necessarily significant; HOTGLOSS will adjust your address list to conform to postal requirements as long as your address mailing list has separate fields for the address line 1 and or address line 2, city, state, and zip code.
Any of the other fields listed below are optional and may be used or not used at your discretion.
* Required Fields
|
Field Name
|
Max Length
|
|
Salutation
|
20
|
|
First Name
|
20
|
|
Middle Initial
|
1
|
|
Last Name
|
30
|
|
Title
|
20
|
|
*Address Line 1
|
45
|
|
Address Line 2
|
45
|
|
Address Line 3
|
45
|
|
Address Line 4
|
45
|
|
Address Line 5
|
45
|
|
Address Line 6
|
45
|
|
*City
|
30
|
|
*State
|
2
|
|
*ZIP Code (ZIP+4)
|
10
|
|
Plus 4
|
4
|
|
Delivery Point
|
3
|
|
Carrier Route
|
4
|
|
Foreign Country
|
30
|
|
Work Phone
|
15
|
|
Work Extension
|
4
|
|
Home Phone
|
15
|
|
Home Extension
|
4
|
|
FAX
|
15
|
|
Group Code
|
5
|
|
Entry Date
|
8
|
|
Comment
|
45
|
|
Street Number
|
10
|
|
Street PreDir
|
10
|
|
Street Name
|
40
|
|
Street Suffix
|
20
|
|
Street PostDir
|
10
|
|
Unit/Apt/Suite
|
10
|
* Required Fields
CREATING A TAB DELIMITED TEXT FILE
Creating a Tab Delimited Text file from
Microsoft™ Excel™
In Excel, open the spreadsheet containing your contacts. Then select File, Save As.In the Save As dialog box, set the Save as type option to Text (Tab delimited)(*.txt).Enter a file name (such as mail_list.txt) for the export file and click Save.If you see a warning about the destination file type not supporting multiple sheets, just click OK.Select the file you just exported (such as mail_list.txt): This is around where you need to browse for the file.
Creating a Tab Delimited Text file from
Microsoft™ Outlook™ Address Book
Click on Contacts in the Outlook Bar, select File, Import and Export.In the Import and Export Wizard, select Export to a file, then click Next.In the Outlook folder, select the Contacts folder and click Next.For the type of the export file, select Comma Separated Values (Windows) and click Next.Enter a file name (such as mail_list.csv) for the export file and click Next.Click Finish to complete the export.Select the file you just exported (such as mail_list.csv) This is around where you need to browse for the file.
Creating a Tab Delimited Text file from
Microsoft™ Outlook Express™ Contacts
In Outlook Express™, select "File" in the Menu Bar, then "Export", then "Address Book".In the Address Book Export Tool dialog box, select the "Text File (Comma Separated Values, csv)" option, and click "Export".In the CSV Export dialog box, enter a name for the export file (such as mail_list.csv), and click "Browse" to save this file somewhere on your computer (i.e. Desktop), then click "Next".If you are not sure which field to export select First Name, Last name and Email Address.Click "Finish" to complete the export.Select the file you just exported (such as mail_list.csv) This is around where you need to browse for the file.
Creating a Tab Delimited Text file from
3Com™ Palm Pilot™ address list
HotSync the contents of your Palm III or your Palm Pilot with the Palm Desktop on your computer.On the Palm Pilot, click the Address icon in the launch bar along the left edge of the desktop window.In the Address Book, select File, Export.In the Export To File dialog box, change the Export as option to Tab Separated Values (*.tab;*txt).Enter a file name (such as mail_list.tab) for the export file, and click Export.In the Specify Export Fields dialog box, do not make any changes-just click OK. Leave all the fields selected, and do not change the field order.Select the file you just exported (such as mail_list.tab): This is around where you need to browse for the file.
Exporting Data to a Delimited Text File from
ACT! 2000 - PC; ACT! 3.0 - PC; ACT! 4.0 - PC
Operating System(s):All Supported
Situation:
You wish to export your ACT! database to another program which will import delimited text files. For example, your mailing company or other vendor requires a delimited text file for their use.
Solution:
Follow these steps to export data for use in another application:
1. Choose File, point to Data Exchange, and then choose Export. The first panel of the Export Wizard appears, asking you the type of file that you want to export and the name and location of the file to which you want to export it.
2. From the File Type drop-down list, choose Text-Delimited.
3. Click the Browse button to the right of the Filename And Location field, locate the file to which you want to export your data and click Save. You can enter the name of a new file, and select the type of text delimited format, (TXT or CSV) from the "Save as type" dropdown list, and ACT! will create the new file for you.
4. Click Next. The next Export Wizard panel asks what kinds of data you want to export. You can export contact records or group records, but you cannot export both record types at the same time. If you want to export both record types, you will have to go through the export process twice by first saving and exporting contact records, then saving and exporting group records.
5. Specify whether to export contact records or group records.
6. (Optional) To specify how ACT! exports the data, click Options. The Export Options dialog box appears.
7. (Optional) Specify the field separator that you want to use when creating your export file, and specify whether to export field names, then click OK. By default, ACT! uses a comma to separate fields when it creates a delimited text file. If the application into which you plan to import the file requires tab-separated fields, select Tab. If you select the Export Field Names option, the first line of the export file will contain the ACT! field names. This can be useful for mapping fields when you import the file into another application.
8. Click Next in the wizard panel. The next Export Wizard panel asks you which contact or group records you want to export.
9. Specify whether to export the current record, the current lookup, or all records in the database, and click Next.
10. The next Export Wizard panel asks you to specify the order in which contact fields from the currently open database will appear in the delimited text file. You can save the field order you specify as a field map that you can reuse when you export data in the future.• To remove a field from the list, select any field name in the list and click Remove Field. When you click Remove Field, the field is removed from the list and will not be exported.
• To quickly replace a field in the list, select the field name you want to replace. In the drop-down list that appears, select the field name that you want to appear in that location. The field that previously appeared in that location is removed from the list.Note: If you remove a field from the list, you can always add the field back to the list by clicking Insert Field and selecting the field in the drop-down list that appears.
11. Do one of the following:
• If you want to save the current field order as a map that you can reuse, click Save Map. In the Save As dialog box that appears, enter a name for the map and click Save. By default, map files are stored in the ACT! folder with a .MAP extension. When you have saved your map, click Finish in the final panel of the Export Wizard to export the data.
• If you want to use a previously saved export map, click Load Map. In the Open dialog box that appears, locate the map file that you want to use and click Open to apply the map. Click Finish to export the data.
• If you do not want to save the map, click Finish to export the data. The data is exported to a delimited text file.
To export GoldMine data:
1 In GoldMine, click Tools > Import/Export Wizard > Export Contact Records.
2 Select Export to a new file.
3 Select ASCII File and click Next.
4 Select All Contact Records.
5 Click Add Field for every field in the "GoldMine Fields" list except for the "Notes" field. Do not add the "Notes" field.
6 Click Next.
7 Enter a filename and select "Export GoldMine field names that has mappings as first record."
8 Select whether you'd like to save these export settings for future use and click Next.
9 Click Finish.
|
|
