home *** CD-ROM | disk | FTP | other *** search
- DATABASE leads
- GLOBALS "globals.4gl"
-
- REPORT r_letter(rr_p, rr_s, rr_c)
- {
- The r_letter report prints letters to prospects, sending
- the output to letter.out. The content of each letter differs
- depending on whether the contact was a complaint, request for
- information, inquiry, or sale.
- }
- DEFINE rr_p RECORD LIKE prospect.*,
- rr_s RECORD LIKE sperson.*,
- rr_c RECORD LIKE contact.*,
- dummy CHAR(20)
-
- OUTPUT
- REPORT TO "letter.out"
-
- FORMAT
- ON EVERY ROW
- SKIP TO TOP OF PAGE
- SKIP 10 LINES
- PRINT rr_p.title CLIPPED, 1 SPACE,
- rr_p.fname CLIPPED, 1 SPACE,
- rr_p.lname
- PRINT rr_p.company
- IF (rr_p.add1 IS NOT NULL) THEN PRINT rr_p.add1 END IF
- IF (rr_p.add2 IS NOT NULL) THEN PRINT rr_p.add2 END IF
- IF (rr_p.add3 IS NOT NULL) THEN PRINT rr_p.add3 END IF
- PRINT rr_p.city CLIPPED, ", ",
- rr_p.state CLIPPED, 2 SPACES,
- rr_p.zip
- SKIP 1 LINE
- LET dummy = MONTH(rr_c.cdate)
- IF dummy = 1 THEN PRINT "January"; END IF
- IF dummy = 2 THEN PRINT "February"; END IF
- IF dummy = 3 THEN PRINT "March"; END IF
- IF dummy = 4 THEN PRINT "April"; END IF
- IF dummy = 5 THEN PRINT "May"; END IF
- IF dummy = 6 THEN PRINT "June"; END IF
- IF dummy = 7 THEN PRINT "July"; END IF
- IF dummy = 8 THEN PRINT "August"; END IF
- IF dummy = 9 THEN PRINT "September"; END IF
- IF dummy = 10 THEN PRINT "October"; END IF
- IF dummy = 11 THEN PRINT "November"; END IF
- IF dummy = 12 THEN PRINT "December"; END IF
- PRINT rr_c.cdate USING " DD, YYYY"
- SKIP 1 LINE
- PRINT "Dear ",
- rr_p.title CLIPPED, 1 SPACE,
- rr_p.lname CLIPPED, ":"
- SKIP 1 LINE
- IF (rr_c.ctype = "C") THEN
- PRINT "I was sorry to hear that you were not satisfied"
- PRINT "with your recent shipment of binders. I hope the"
- PRINT "issue has been settled to your satisfaction. If"
- PRINT "not, do not hesitate to contact me."
- END IF
-
- IF (rr_c.ctype = "I") THEN
- PRINT "Thank you for your request for information. I"
- PRINT "will be sending you literature under separate"
- PRINT "cover."
- END IF
-
- IF (rr_c.ctype = "Q") THEN
- PRINT "Thank you for your recent inquiry. I hope you"
- PRINT "have had all your questions answered. I will be"
- PRINT "sending you our literature under separate cover."
- END IF
-
- IF (rr_c.ctype = "S") THEN
- PRINT "Thank you for your recent purchase. I hope the"
- PRINT "binders meet your requirements and that we can"
- PRINT "continue to do business together in the future."
- END IF
-
- PRINT FILE "para"
- IF rr_s.add1 IS NOT NULL THEN PRINT rr_s.add1 END IF
- IF rr_s.add2 IS NOT NULL THEN PRINT rr_s.add2 END IF
- IF rr_s.add3 IS NOT NULL THEN PRINT rr_s.add3 END IF
- PRINT rr_s.city CLIPPED, ", ",
- rr_s.state CLIPPED, 2 SPACES,
- rr_s.zip
- PRINT "telephone: ", rr_s.phone
- SKIP 1 LINE
- PRINT "Sincerely,"
- SKIP 4 LINES
- PRINT rr_s.fname CLIPPED, 1 SPACE,
- rr_s.lname CLIPPED, ", ",
- rr_s.position
- PRINT "Associated Binder Company"
- END REPORT
-