The following are instructions to export information from the Vermont Media Directory into Microsoft Word to create mailing labels. Please note if you are using a version of Microsoft Word older than Word ’95, these instructions may not work.

Depending on your familiarity with computers, this process may seem complicated. Unfortunately, we at Kelliher Samets Volk do not have the resources to provide technical support for this aspect of our product.

We encourage you to try this process on your own. If you are experiencing difficulty, please attempt to seek out either an IT person or a computer-savvy individual in your office that may be able to assist you.

  1. Search for the media in the directory that you wish to mail to (e.g. all newspapers, all business publications, all listings, etc.).

  2. You will then be presented with a Search Results page. At the top of thispage, click on "Download Mailing Labels."

  3. Your computer will download a file named "MailingLabels.xls." On Mac, this will download to your computer. On Windows, you have the option of opening the file or saving it to your computer. If you open it, make sure you save it.

    If you're on Windows, you're now ready to do a Mail Merge. If you're on a Mac, you'll need to open "MailingLabels.xls" in Excel and do a "Save As..." You can choose the same name or a name of your choice. In this example, we'll save as "MailingLabels.xls."

  4. Now open the application, Microsoft Word and create a new document.


  5. Go to the "Tools" menu and click Mail Merge. A Mail Merge Helper window will appear.

    If you have newer version of Word you'll see Data Merge Manager. Clicking on this will open the Data Merge Manager window.

  6. Under the title Main Document, click Create, click Mailing Labels and then click Active Window. Your open document will become the mail-merge document.

  7. Under the title "Data Source", click Open Data Source. Then open "MailingLabels.xls."

  8. Click Set Up Main Document.

  9. Then a "Label Options" window will appear. Under the title "Product Number," select the mailing label format of your choice. The standard address label is "5160."

  10. Next a "Create Labels" window will appear. Here, you can choose the order in which you wish the information to be placed on the label. (e.g. contact name first, media name second, street address third, etc.)

  11. Under the Insert Merge Field pull-down menu, click Contact [hit return], click Name [hit return], click Add1 [hit return], click City [type a comma] [type a space], click State [type a space], click Zip. Then click OK.

  12. Under the title "Merge the Data with the Document," click Merge. In the next window click Merge again.

  13. All of your information should now be presented in mailing label format. Remember to save your document and you will be able to use this template again and again without repeating this process.

  14. Finally, print onto mailing labels and you are done.

NOTE: In some cases, the information may not completely fit on the label due to long company names or addresses. The Word template you have created may be edited manually as necessary, to better fit the information.