|














|

|
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.
- Search for the media
in the directory that you wish to mail to (e.g. all newspapers, all
business publications, all listings, etc.).
- You will then be presented
with a Search Results page. At the top of thispage, click on
"Download Mailing Labels."
- 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."
- Now open the application,
Microsoft Word and create a new document.
- 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.
- Under the title Main Document,
click Create, click Mailing Labels and then
click Active Window. Your open document will become the
mail-merge document.
- Under the title "Data
Source", click Open Data Source. Then open "MailingLabels.xls."
- Click Set Up Main Document.
- 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."
- 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.)
- 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.
- Under the title "Merge
the Data with the Document," click Merge. In the
next window click Merge again.
- 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.
- 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.
|