home *** CD-ROM | disk | FTP | other *** search
/ Frostbyte's 1980s DOS Shareware Collection / floppyshareware.zip / floppyshareware / DOOG / QATEMPLA.ZIP / MAILLIST.DTF (.txt) < prev    next >
Symantec Q&A Database File  |  1990-03-13  |  70KB  |  345 lines

  1. SYMANTEC TOUCHBASE DATABASE
  2. rrison x8980
  3. John Jones
  4. rrison x8980
  5. 1989/08/133FeldkampDavid(415) 926-2915(415) 926-1784YTechnical Support SupervisorNDynamic DrivesY2267 Brady RoadYSan FranciscoCA930231965/12/01Barbara WilliamsNov 24(415) 394-3392Diane32 Payton PlaceSan FranciscoCA93023FeldkampDavid2267 Brady Road
  6. President
  7. Vice President
  8. Manager
  9. Supervisor
  10. Secretary
  11. Administrative Assistant
  12. Engineer
  13. Technician
  14. Peach DriveSan JoseCA95110HarteCarol18HarteCarolea Code:
  15. 1989/09/152LimsnerMichael(415) 7835
  16. Person
  17. People
  18. Friend
  19. Buddy
  20. DevelopmentYP.O. Box 345Y7
  21. Person
  22. uePacificaCA94033LimsnerMichaelP.O. Box 345    
  23. /=327-3956Product Manager213Hi
  24. 5,AS,CS9,AS,CS101,IS,MB)1
  25. !Contact List by Company!<#>
  26. !@date(11)
  27. E;W;N;S;MW;ME
  28. Notes:A
  29. For all phone and fax numbers in the form, you may enter them in one of the following formats:                      
  30.                                         
  31. 4085551212 or 408 555 1212 will become (408) 555-1212
  32.                                         
  33. 5551212 or 555 1212 will become 555-1212
  34. -1212
  35. !Month
  36. @month$(#1)
  37. @month(#1)
  38. 2,AS,I
  39. 1989/08/251JohnsonRandall(213)
  40. !Birthdays List
  41. !@date(11)
  42. !- # -
  43. treetOrangeCA92022Mary Jones(213) 254-3322Rachel786 
  44. Rolodex......
  45.  827-4916(408) 827-
  46. eCarol(408) 827-4916(408) 827-
  47. 1,AS9/12/191990/01/186YHarteCa
  48. Count
  49. 2,SC,C
  50. HEN @HELP(#70)>#70:LOOKUP(#70,1,#70)>#80:IF @LEN(@NUM
  51. !Count of each zipcode
  52. N(@NUM(#80))=10 THEN #80="("+@LEFT(@NUM(#80),3)+") "+@MID(@NU
  53. You may enter one of the following letters for the zone.  The complete zone description will be looked up.
  54. E - East                                               
  55. W - West                                               
  56. N - North                                              
  57. S - South                                              
  58. MW - Midwest                                           
  59. ME - Mideast
  60.  Mideast
  61. 1989/12/195WilliamsSandy(408) 482-8928(408) 482-4026YMarketing ManagerNComputer DirectionsY899 Cantebury LaneYSan JoseCA951101941/06/02Fran ThomasMay 26(415) 885-8756Stanley2755 Woodmark CircleSan FranciscoCA94287WilliamsSandy899 Cantebury Lane
  62. Lookups available:      
  63. P : President                  E: Engineer
  64. VP: Vice President             T: Technician
  65. M : Manager             
  66. S : Supervisor          
  67. SE: Secretary           
  68. AA: Administrative Assistant
  69. @DATE@NUMBERYNYY
  70. 1,AS,CS23456
  71. !List of Contacts
  72. @date
  73. Page #
  74. Birthdays
  75. Zipcode Counts
  76. Phone Numbers of Contacts
  77. 5AS6AS1AS
  78. List of Contacts
  79.                     Mail List Management
  80. This database will help you track people. You can store work and home information with notes.  The status section is used to mark each record for future mailings or printings. The week prior to his birthday is automatically calculated.
  81.  week before his birthday.
  82. 1989/12/194HarteCarol(408) 827-4916(408) 827-4927YPublic Relations ManagerNMirror Image SystemsY3567 Westridge AvenueYSan JoseCA95110Phillip Daubs(408) 324-9802Charles840 Peach DriveSan JoseCA95110HarteCarol3567 Westridge Avenue                
  83. Telex #:
  84.            8
  85. <#1000:goto #1#1>#2:if #100 <>9
  86.  ""; #100 = #1 + #2;if @add and #300 = "" and :
  87. Record #
  88. Records
  89. Highest
  90. Lowest
  91. hen goto #200 el;
  92. Last Name
  93. elp in formatting phone and fax numbers."<
  94. First Name
  95. =7 THEN #50=@LEFT(@NUM(#50),3)+"-"+@RIGH=
  96. Work Phone
  97. Phone
  98. ))=10 THEN #50="("+@LEFT(@NUM(#50>
  99. UM(#50),4,3)+"-"+@MID(@NUM(#50),7,4)>#20:IF @LE?
  100. Title
  101.  #20=@LEFT(@NUM(#20),3)+"-"+@RIGHT(@NUM(#20),@
  102. Label........
  103. EN #20="("+@LEFT(@NUM(#20),3)+") "+@MA
  104. Company
  105. Business
  106. (#20),7,4)>#55: lookup(#55,1,#55)B
  107. Holiday Card.
  108. : goto #65>#94:goto #106>#65:#103 = #C
  109. Address 1
  110. #202#75#85#95>#97: goto #98>#202:#203 = @D
  111. Birthday Card
  112.  @str(@dom(#202-7)); goto #80#98>#99:E
  113. Address 2
  114. N(@NUM(#80))=7 THEN #80=@LEFT(@NUM(#80),3F
  115. #80),4);IF @LEN(@NUM(#80))=10 THEN #80="("+@LEG
  116. State
  117. "+@MID(@NUM(#80),4,3)+"-"+@MID(@NUM(#80),7,4)H
  118.  then {#50=#210;#20=#220;#55=#225;#60=#230;#65=I
  119. Birthdate
  120. 7=#255}; #200="";#205="";#210=J
  121. Secretary
  122. ="";#235="";#240="";#245="";#250="";#255=K
  123. Telex #
  124. goto #80 else goto #50<#200 = #1; goto #205L
  125. 210<#210 = @xlookup(@filename,#100, "Last/FirsM
  126. H-Phone
  127. ); goto #220<#220 = @xlookup(@filename,#100N
  128. Spouse's Name
  129. ; goto #225<#225 = @xlookup(@filenameO
  130. H-Address
  131. ", "Title"); goto #230<#230 = @xlookup(@fP
  132. H-City
  133. First Name", "Company"); goto #235<#235 = @xQ
  134. H-State
  135. , "Last/First Name", "Address 1"); goto #24R
  136. H-Zip
  137. filename,#100, "Last/First Name", "Address 2"S
  138. Notes|
  139. Comment
  140. @filename,#100, "Last/First Name", T
  141. Duplicate this record? (Y/N)
  142. me,#100, "Last/First NU
  143. Last/First Name
  144. 5 = @xlookup(@filename,#100, "Last/V
  145. Address
  146. #300 = "N"; goto #300#100#103
  147. Address 1
  148. Jan 30, 1990
  149. 3:52 pm
  150.           Q&A WRITE -- B. Emerald                                                                                                                                    
  151.                      
  152.  MAIL LIST MANAGER 
  153.           
  154.  Date:AA            
  155.  Contact's Name 
  156.  Record #:AB        
  157. Last Name:AC                         First Name:AD                            
  158.  Work Information 
  159.  Status 
  160. (Y/N)
  161. Work Phone:AE                      > Fax:AF               
  162.  Rolodex......<  > 
  163. Title:AG                                           >      
  164.  Label........<AH> 
  165. Company:AI                                         >      
  166.  Holiday Card.<AJ> 
  167. Address 1:AK                                       >      
  168.  Birthday Card<AL> 
  169. Address 2:AM                                       >      
  170.  Birthdate 
  171. City:AN                     > State:AO    Zip:AP         >
  172.  Born<AQ          >
  173. Secretary:AR                 > Telex #:AS                 
  174.  Send<AT          >
  175.  Home Information 
  176. H-Phone:AU                           Spouse's Name:AV                         
  177. H-Address:AW                         >                                        
  178. H-Address:AX                         >                                        
  179. H-City:AY                          > H-State:AZ  H-Zip:Aa                     
  180.  Notes|<Ab
  181.                                                                                >
  182.  Caution! - Duplicate Record 
  183.  The name which you have just typed in has been previously entered into this  
  184.  database. If you would like to move it to this record type Y or else type N. 
  185.  Note| you will be creating a duplicate record.  If you do not want to create 
  186.  the duplicate you can use Search/Update to select and modify the old record. 
  187.                                                                               
  188.  Duplicate this record? (Y/N) <a> 
  189.                                                                               
  190.  Last Name:Ac                         > First Name:Ad                       > 
  191.                                                                               
  192.  Work Phone:Ae                        > Fax:Af                          >     
  193.  Title:Ag                             >                                       
  194.  Company:Ah                           >                                       
  195.  Address 1:Ai                         >                                       
  196.  Address 2:Aj                         >                                       
  197.  City:Ak                              > State:Al    Zip:Am              >     
  198.                                                                               
  199.  Do not change this field 
  200.  Last/First Name:An                                                           
  201.  Address:Ao                                                                   
  202. 1989/09/152LimsnerMichael(415) 783-9871(415) 783-0327YProgrammerNSoftware DevelopmentYP.O. Box 345Y345 B Gram WayPacificaCA940331961/06/14Jennifer McCabe6/7(415) 394-8937Michelle947 Willow AvenuePacificaCA94033LimsnerMichaelP.O. Box 345Search/Update to select and modify the old recor
  203. 00<0u
  204. PSQRWV
  205. ^_ZY[X
  206. SQRWV
  207. ^_ZY[
  208. SQRVWU
  209. .u4Q&
  210. ]_^ZY[
  211. SQRWV
  212. ^_ZY[
  213. PSQRWV
  214. ^_ZY[X
  215. SQRWVU
  216. ]^_ZY[
  217.   =ont
  218. y8r"+
  219. *b238WY
  220. *b238W
  221. *b238W
  222. Full Name
  223. !X#100
  224. !X#100
  225. !Press [F1] for help in formatting phone and fax numbers.
  226. !Press [F1] for help on Title.
  227. !Last/First Name
  228. !Work Phone
  229. !Last/First Name
  230. !Last/First Name
  231. !Title
  232. !Last/First Name
  233. !Company
  234. !Last/First Name
  235. !Address 1
  236. !Last/First Name
  237. !Address 2
  238. !Last/First Name
  239. !City
  240. !Last/First Name
  241. !State
  242. !Last/First Name
  243. Enter the Date of Birth of the Contact into the Born field.
  244.               
  245. The Send field will calculate automatically to the day that the Birthday card should be sent. (1 week before)
  246.         
  247. 5x4+,537x38x,210x1x15x20x25+,330+,335x40x,2
  248.  Work Inf2
  249. 1989/08/251JohnsonRandall(213) 327-5947(213) 327-3956YProduct ManagerNHiTech DataYP.O. Box 322Y322 N. Elm StreetOrangeCA920221965/06/01Mary JonesMay 25(213) 254-3322Rachel786 Old Bridge WayOrangeCA92022JohnsonRandallP.O. Box 322W
  250.  MAIL LIST MANAGER 
  251.           
  252. Date:
  253.              
  254.  Contact's Name 
  255.     Record #:
  256.              
  257. Last Name:
  258.                           
  259. First Name:
  260.                              
  261.  Work Information 
  262.  Status 
  263. (Y/N)
  264. Work Phone:
  265.                         
  266.                 
  267. Rolodex......
  268. Title:
  269. -                                             
  270. Label........
  271. Company:
  272. +                                           
  273. Holiday Card.
  274. Address 1:
  275. )                                         
  276. Birthday Card
  277. Address 2:
  278. )                                         
  279.  Birthdate 
  280. City:
  281.                        
  282. State:
  283.      
  284.            
  285.             
  286. Secretary:
  287.                    
  288. Telex #:
  289.                   
  290.             
  291.  Home Information 
  292. H-Phone:
  293.                             
  294. Spouse's Name:
  295.                           
  296. H-Address:
  297.                            
  298. H-Address:
  299.                            
  300. H-City:
  301.                             
  302. H-State:
  303. H-Zip:
  304.                       
  305. Notes|A
  306.  Caution! - Duplicate Record 
  307.  The name which you have just typed in has been previously entered into this  
  308.  database. If you would like to move it to this record type Y or else type N. 
  309.  Note| you will be creating a duplicate record.  If you do not want to create 
  310.  the duplicate you can use Search/Update to select and modify the old record. 
  311.                                                                               
  312. Duplicate this record? (Y/N)
  313.                                                                               
  314. Last Name:
  315.                            
  316. First Name:
  317.                          
  318.                                                                               
  319. Work Phone:
  320.                           
  321.                             
  322. Title:
  323.                                
  324. Company:
  325.                              
  326. Address 1:
  327.                            
  328. Address 2:
  329.                            
  330. City:
  331.                                  
  332. State:
  333.      
  334.                 
  335.                                                                               
  336. <AY    4
  337.  Do not change this field 
  338. Last/First Name:
  339. <                                                            
  340. Address:
  341. D                                                                    
  342. <#1000:goto #1#1>#2:if #100 <> #1+#2 then #300 = ""; #100 = #1 + #2;if @add and #300 = "" and @xlookup(@filename,#100,"X#100","X#100") <> "" then goto #200 else @msg("Press [F1] for help in formatting phone and fax numbers.")>#50:IF @LEN(@NUM(#50))=7 THEN #50=@LEFT(@NUM(#50),3)+"-"+@RIGHT(@NUM(#50),4);IF @LEN(@NUM(#50))=10 THEN #50="("+@LEFT(@NUM(#50),3)+") "+@MID(@NUM(#50),4,3)+"-"+@MID(@NUM(#50),7,4)>#20:IF @LEN(@NUM(#20))=7 THEN #20=@LEFT(@NUM(#20),3)+"-"+@RIGHT(@NUM(#20),4);IF @LEN(@NUM(#20))=10 THEN #20="("+@LEFT(@NUM(#20),3)+") "+@MID(@NUM(#20),4,3)+"-"+@MID(@NUM(#20),7,4); @msg("Press [F1] for help on Title."); goto #55>#91:goto #92>#55: lookup(#55,1,#55); goto #60>#92:goto #94>#60: goto #65>#94:goto #106>#65:#103 = #65; goto #75>#106:goto #202#75#85#95>#97: goto #98>#202:if #106="Y" then {#203 = @str(@left(@month$(#202-7),3)) + " " + @str(@dom(#202-7));} else #203="";goto #80#98>#99:goto #91#203>#80:IF @LEN(@NUM(#80))=7 THEN #80=@LEFT(@NUM(#80),3)+"-"+@RIGHT(@NUM(#80),4);IF @LEN(@NUM(#80))=10 THEN #80="("+@LEFT(@NUM(#80),3)+") "+@MID(@NUM(#80),4,3)+"-"+@MID(@NUM(#80),7,4)>#1050: goto #1>#300:if #300="Y" then {#50=#210;#20=#220;#55=#225;#60=#230;#65=#235;#75=#240;#85=#245;#95=#250;#97=#255}; #200="";#205="";#210="";#220="";#225="";#230="";#235="";#240="";#245="";#250="";#255=""; if #300="Y" then goto #80 else goto #50<#200 = #1; goto #205<#205 = #2; goto #210<#210 = @xlookup(@filename,#100, "Last/First Name", "Work Phone"); goto #220<#220 = @xlookup(@filename,#100, "Last/First Name", "Fax"); goto #225<#225 = @xlookup(@filename,#100, "Last/First Name", "Title"); goto #230<#230 = @xlookup(@filename,#100, "Last/First Name", "Company"); goto #235<#235 = @xlookup(@filename,#100, "Last/First Name", "Address 1"); goto #240<#240 = @xlookup(@filename,#100, "Last/First Name", "Address 2"); goto #245<#245 = @xlookup(@filename,#100, "Last/First Name", "City"); goto #250<#250 = @xlookup(@filename,#100, "Last/First Name", "State"); goto #255<#255 = @xlookup(@filename,#100, "Last/First Name", "Zip"); #300 = "N"; goto #300#100#103                   
  343. 1989/08/133FeldkampDavid(415) 926-2915(415) 926-1784YTechnical Support SupervisorNDynamic DrivesY2267 Brady RoadYSan FranciscoCA930231965/12/01Barbara WilliamsNov 24(415) 394-3392Diane32 Payton PlaceSan FranciscoCA93023FeldkampDavid2267 Brady RoadA920221965/06/01Mary JonesMay 25(213) 254@
  344. chel786 Old Bridge WayOrangeCA92022JohnsonRandallP.O.
  345.