PORTALPRODIGY makes it easy for administrators to create mailing
labels or merge members' addresses into form letters using Microsoft Word or
their favorite word processing application. It does this by exporting an open
standard file called a Comma Delimited File, also commonly known as a CSV.
This tutorial will show how to:
- Search for a targeted group of mail prospects
- Export a .csv file
- View the .csv file with Microsoft Excel or Microsoft
Word 2000
- Import the .csv file into Microsoft Word 2000 mail
merge document
- Print the labels on Avery labels or their equivalent
From the Administration Menu, click on the Contacts Report
Icon. 
Select MailListExportReport from the list by clicking
on its label.
Select the desired Special Interest Groups by clicking on
their label. You may select multiple items by using ctrl-Click. Then click on
the Create Export File button.
A second browser widow will open while the list processes.
The size of the list will determine how long it takes to process. Depending on
your bandwidth, computer speed and server load estimates can range fro .01
second per name to 3 seconds per name.
A dialog box will open at some point asking:
Would you like to
open the file or save it to your computer?
Select Save.
Select a desirable folder and file name then select Save.
At this point you can log off the website and Internet if you wish to
because the .csv file is saved on your computer.
To view the data file start your Microsoft Excel Spread
Sheet , Microsoft Word, Notepad, or similar application program. The file
appears different in a text editor than it does in a spread sheet but the same
data is there. For example, Microsoft Word shows the comma delimiters and quote
text qualifiers while Excel uses the comma delimiters and quote text qualifiers
to place the data into the proper columns. You can learn more about delimiters
in Appendix D.
You won't need the .csv file open to create labels. So if
the file is open, close it.
The following instructions are specific to Microsoft Word
2000. If you are using a different mail merge or word processing application
review the section on merging delimited database files.
Open a blank document in Microsoft Word. Then, select Mail
Merge from the Tools command menu.
Click on the Create button of the Mail Merge Helper
dialog window.
Select Mailing Labels… from the pull down list of the
Create button.
Then select Open Data Source… from the Get
Data button pull down selection list.
Locate the .csv file you wish to merge and open it.
Select the appropriate settings for your printer and labels
(we use Avery 5160) and click OK in the Label Options dialog window.
Select the fields you wish to show on your labels by
selecting from the Insert Merge Field button on the Create Labels dialog
window. It’s a process that must be repeated for each field you wish to include
on your label so, don’t click the OK button until each desired field has been
selected.
As you select fields, they will appear in the Sample Label
box in the Create Labels dialog window. You can use Tabs, Spaces and Carriage
Returns in the Sample Label box to format the label.
When the label layout is complete, click on the OK button.
Generally, the default settings in The Merge dialog window
are appropriate but you can update them if desired. Then, Click on the Merge
button.
Send your labels to the printer!!!
