Wild Ones   Mail Merge Help  
After the addresses are displayed, save the displayed page as a text file. On your browser, click on the upper left "File", "Save As". Some browsers will ask you choose "Save as type", you should choose "Text File (*.txt)". The "File name" should be a name you can easily remember, and end in a ".txt" suffix, e.g., "labeldata.txt". Some browsers may warn that the page may not be saved properly as a web page; answer yes to continue. Make sure you "Save in" a folder on your computer that you can remember as well. Finally click on "Save". Then, you can import that file into Mail Merge, using Microsoft Word, and print the formated adresses on address labels. We have also provided templates you can use; use labelmain.doc if the labels are not sorted by date, or labeldate.doc if you had chosen to sort by ActionDate or Expire, and the date will appear above the name in the label. So we suggest you save these 2 files by right-clcking on the above 2 links above and "Save Link As" in the same folder that you save the text file.

We suggest printing on Avery 8160 (1" x 2.63") labels, these should be big enough for most needs. If anyone has instructions for other versions of Word, or for Excel, please write them down and forward to webmaster. Thank you.


Instructions for Word97:
0. Open labelmain.doc or labeldate.doc as the template for Mail Merge.
1. If a dialog box pops up, click on "Find Data Source", and open the file you had saved, e.g. "labeldata.txt".
2. Click Tools -> Mail Merge.
3. Click Get Data -> Open Data Source, and open the text file you had saved, e.g. "labeldata.txt", if you hadn't done so in 1.
4. Click Merge.
5. A dialog box pops up; you can accept the default values and click on "Merge".
Instructions for Word 2000:
  1. Open Microsoft Word and bring up the file you just saved. Edit it by dropping those names not wanted. This is also where you can correct addresses etc. Save as a word document because Word mail merge won?t use text files.
  2. Make a template. In Word click on File on the toolbar, then new. In the resulting box select template then OK. Then click on file, save as, and give this new template an appropriate name of your choosing such as memlabelexpire. While in this template choose Tools, mail merge. In the mail merge helper box etc. Follow the second set of instructions in Mail Merge Help starting with 2.
  3. After a fleeting glimpse of what you think will be your address labels they disappear but are found on your task bar. Click to bring up and then save as desired and print, etc.
  4. When doing this the next time your template is ready to go and you get it by going to file, new, template and double clicking on your creation. Import the new data set from the Internet by saving as a text file, then changing to a Word file as mentioned above.

Instructions for Word 2002:
  1. Open labelmain.doc or labeldate.doc as the template for Mail Merge.
  2. Click Tools -> Letters and Mailings -> Mail Merge Wizard.
  3. You should be in Step 3 of 6. Select "Use an existing list". Make sure under "Use names and addresses from a file or a database", the wizard is showing the .txt you had saved, e.g. "labeldata.txt". If not, click the button to select a different file; the buttin may say something like "Select a different list" or "Browse". A window may pop up asking you to select Field and Record delimiter; select "(Tab)" and "(enter)" respectively. Click Next.
  4. You should be in Step 4 of 6. Click Next.
  5. Step 4 of 6: Click Label options to select your label. We suggest Label product Avery standard, Product number 8160 - Address.
  6. You should be in Step 3 of 6. Select "Use an existing list". Make sure under "Use names and addresses from a file or a database", the wizard is showing the .txt you had saved, e.g. "labeldata.txt". If not, click the button to select a different file; the buttin may say something like "Select a different list" or "Browse". A window may pop up asking you to select Field and Record delimiter; select "(Tab)" and "(enter)" respectively. Click Next.
  7. You should be in Step 4 of 6. Click Next.



Home © Wild Ones®. All rights reserved.
Updated: Jun 12, 2005.
webmaster