re: Printing address labels...

From: Peter A. Grant <grant_at_reg.triumf.ca>
Date: Wed, 10 Jun 1992 22:14:00 GMT
Message-ID: <10JUN199215140626_at_reg.triumf.ca>

(Hi Eva.)

This is a sample that pulls of labels for one of our conferences:

clear break
clear columns
set linesize 80
set pagesize 9999
set feedback off
set termout off
set heading off
set recsep off
set wrap on
column New_Name format a80
column institution format a80
column Division format a80
column Street format a80
column City format a80
column CountryPostal format a80
column Surnames noprint
spool dsk2:[cyclotrons92]LABELS.LIS
select berlin.TITLE||' '||FIRSTNAMES||' '||SURNAMES New_Name,

       Institution,
       Division,
       STREET,
       City,
       Country||' '||Postal CountryPOSTAL

from berlin,papers
where papers.author = berlin.seq and papers.ack = 'S' order by Surnames,Firstnames;
spool off
set termout on
set recsep wrapped
clear columns
clear breaks
clear computes Received on Thu Jun 11 1992 - 00:14:00 CEST