Run your entire organization from the Internet
 
1
Broadcasting Features in Detail
previousTable of ContentsSearchKeywords Indexnext

Create Mailing Labels and Mail Merge Files

 

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. Report

 

 

 

 

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!!!

 

 

 


previousTable of ContentsSearchKeywords Indexnext

© PortalProdigy, Inc. 2000-2007
 
©2000-2024 Portal Prodigy, Inc.©1994-2024 Brolin Corporation