It might all seem intimidating at first, but Mail Merges are actually pretty simple. At its most basic level, your Data List may contain information such as NAME, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, etc. The first row of data is usually the name/label of the column, and subsequent rows contain the actual data. It's that simple! Listed below, you'll find two popular programs that we recommend for creating Data Lists, along with sample template files for your convenience:
1. Open Microsoft Excel and add in any pertinent data:
2. Once completed, go to the main menu of Excel and click SAVE AS:

3. From here, you can save the file as a *.CSV (separated by commas), *.TXT (separated by tabbed spaces), *.XLS, or *.XLSX file. Note that while in Excel, the program will automatically arrange your data based on which filename you choose to SAVE AS:

1. Open your favorite text-editor (we recommend Notepad) and add in any pertinent data, separated by tabs (for .TXT files) or commas (for .CSV files), as shown below. There should be one tab between each column (columns may not necessarily appear lined up):

2. Once completed, go to the FILE tab and click SAVE AS. From here, you can save the file as a *.TXT file (if separated using tabbed-spaces) or a *.CSV file (if separated using commas):

| Customer Support | Shopping | Miscellaneous | Company Information | |
|
|
Toll Free: 1-888-575-2235 Online Labels, Inc. |
![]() |
![]() |
|
© 2012 Copyright Online Labels, Inc. All Rights Reserved. Privacy Policy | Terms of Service
|