Sensory Computer Systems Forums Index Sensory Computer Systems Forums
Welcome to the Sensory Computer Systems Online Forums!
 
 FAQFAQ   SearchSearch   RegisterRegister 
 ProfileProfile   Log inLog in   
   Sensory Computer Systems Home   

Q. How do I print mailing labels for panelists?

 
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> General Forum
View previous topic :: View next topic  
Author Message
PAL



Joined: Jun 01 2005
Posts: 24

PostPosted: Tue Jun 14, 2005 2:51 pm    Post subject: Q. How do I print mailing labels for panelists? Reply with quote

A. From the Reports Pull-Down menu, choose Panelist Reports.., then Panelist Master Report.




  1. Choose Panelist Mailing Label Info (Name & Address).
  2. Select panelists to include in the report. You can do this either manually or through the Specify Selection Criteria option.
  3. Click Create Report.
  4. Optionally click View/Print Report to see if it includes all the information you want.
  5. Click Export Mailing Label Info to Excel to export the panelist names and addresses to an Excel file.

    For further information on printing panelist mailing labels, click Notes - Reports Types.

  6. Save the Excel spreadsheet under a new name. You may want to delete rows with insufficient address information first.

Now you are ready to create the mailing labels using Microsoft Word.

The exact procedure to follow depends on which version of Word you are using.

For reference you may want to view
http://office.microsoft.com/en-us/assistance/HA011903941033.aspx which displays a demonstration of creating mailing labels using Microsoft Office Word 2003.

If you have an older version of Word, the document at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;141992 may be more helpful.

Regardless of which version of Word you are using, you will still have to define the fields on each label in accordance with the layout on the Excel spreadsheet. The label fields should look like this:

«Panelist_Name»
«Street_Address»
«City_State_Zip»
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> General Forum All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group