home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload / ShartewareOverload.cdr / database / maint301.zip / MAINTA30.ZIP / MERGE.DOC < prev    next >
Text File  |  1988-10-09  |  5KB  |  124 lines
  1.             WordStar/MailMerge[TM]/Basica/Output Sequential File
  2.               [also: WordPerfect[TM] Merge and dBASE III [TM] ]
  3.  
  4.                                   OVERVIEW
  5.  
  6. Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼á WordPerfect[TM]¼á o≥ ì
  7. dBAS┼á II╔á [TM▌ datß filσ usinτ thσ datß froφ you≥ Maste≥á File/dBAS┼á II╔ ì
  8. file« Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ '.SFº o≥ '.DBF'.
  9.  
  10. Iµ useΣ witΦ Wordstar[TM]¼á thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφ letter≤ ì
  11. iε MailMerge[TM]«á  Al∞ characte≥ field≤ arσ  trimmeΣ oµ trailinτ blank≤ t∩ ì
  12. accommodatσá you≥ forφ letters«á   Alonτ witΦ thi≤ datß file¼á thσ Wordsta≥  ì
  13. optioεá create≤á thσ beginninτ oµ  you≥ forφ lette≥ anΣ put≤ i⌠ iεá ßá filσ ì
  14. endinτá iε thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌á command≤ ì
  15. yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)« 
  16.  
  17. Iµá useΣ witΦ WordPerfect[TM]¼á thσ .S╞ filσ i≤ thσ 'Secondar∙á Fileºá tha⌠  ì
  18. WordPerfec⌠á use≤á fo≥ mergσ letters¼á  wherσ eacΦ fielΣ i≤ delimiteΣá witΦ ì
  19. CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]
  20.  
  21. Iµ useΣ witΦ dBAS┼ II╔ [TM]¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ß standarΣ ì
  22. datßá filσ forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á thei≥á respectivσ ì
  23. datß impor⌠ function.
  24.  
  25. Thesσá option≤á  wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iεá you≥á prospec⌠ ì
  26. filσá t∩á aεá externa∞á tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣá b∙á ßá worΣ ì
  27. processo≥ t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.
  28.  
  29. BaseΣá oε you≥ selectioε criteria¼á iµ any¼á thσ prograφ wil∞ outpu⌠á thesσ ì
  30. fields║ 
  31.                  Primar∙ ID¼ Secondar∙ ID¼ 3rΣ ID¼ Comment≤ 
  32.  
  33.  
  34.                                ==============
  35.                                |  OPTION 1: |
  36.                                ==============
  37.  
  38.                              Selection Process:
  39.  
  40. A⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥ 
  41. you≥ worΣ processo≥ mergσ file║ 
  42.  
  43.                  Primary ID, Secondary ID, 3rd ID, Comment≤ 
  44.  
  45. Yo⌡á caε selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩  bσ  selecteΣá  tha⌠  ì
  46. havσá al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠  record≤ regardles≤á oµ ì
  47. thσ numbe≥ oµ  matche≤ madσ pe≥ record¼á  a≤ lonτ a≤ a⌠  leas⌠ onσ matcΦ i≤ ì
  48. madσ iε an∙ onσ recorΣ tha⌠ i≤ selected.
  49.  
  50. Truσ  [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠  t∩ 
  51. bσ  selected«   Falsσ  [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε  ß 
  52. recorΣ i⌠ wil∞ bσ selected.
  53.  
  54.  
  55. è                         Search Criteria Selection:
  56.                                  Option 1:
  57.  
  58. Yo⌡ caε ente≥ an∙ word¼á  phrase¼  o≥ codσ oε whicΦ t∩  basσ you≥ selection«  ì
  59. Iµá lef⌠ blank¼á  al∞ record≤ wil∞ bσ selecteΣ out«á   Iµ yo⌡ makσ aεá entr∙ ì
  60. here¼á  thσá prograφ wil∞ searcΦ througΦ thσ prospec⌠ filσ  anΣ  selec⌠á ou⌠ ì
  61. onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.
  62.  
  63. [Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσá anΣ ì
  64. al∞á  record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ  o≥ an∙  combinatioε ì
  65. oµ them]
  66.  
  67.                                ==============
  68.                                |  OPTION 2: |
  69.                                ==============
  70.                 2)  Output records to Wordstar/Mailmerge[TM]  
  71.  
  72. Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Master File filσ anΣ outpu⌠ i⌠á t∩á ß ì
  73. filσá tha⌠á caε bσ useΣ b∙ WordStar/MailMerge[TM]«á  Thi≤  filσ caε als∩á bσ ì
  74. useΣ b∙ BASI├ anΣ othe≥ language≤ anΣ products«á Iε short¼á an∙ produc⌠ tha⌠ ì
  75. accept≤á "commß delimitedó file≤ fo≥ inpu⌠ ma∙ accep⌠ thσ  filσá createΣá b∙ ì
  76. thi≤ option.
  77.  
  78. Froφ thσ WordSta≥ option¼á yo⌡ wil∞ creatσ  tw∩ files«  Thσ firs⌠ filσ namσ ì
  79. end≤á iε .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ß forφ lette≥á jus⌠á b∙ ì
  80. callinτ i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφ letter«á  I⌠ alread∙ ì
  81. contain≤á al∞á oµá thσá command≤á needeΣ b∙ WordSta≥á t∩á reaΣá thσá Maste≥ ì
  82. File/dBAS┼ II╔ datß filσ (.DAT).
  83.  
  84. Thσ othe≥  filσ i≤ thσ .DA╘ file¼á whicΦ contain≤ al∞ datß tha⌠ yo⌡ wan⌠ t∩ ì
  85. reaΣ int∩ WordStar«á  I⌠ i≤ formatteΣ sequentia∞ file¼á witΦ al∞ field≤á iε ì
  86. quote≤ anΣ separateΣ b∙ commas« 
  87.  
  88.  
  89.                                ==============
  90.                                ⁿ  OPTIO╬ 3║ |
  91.                                ==============
  92.  
  93.                    3)  Output records to WordPerfect[TM] 
  94.  
  95. Thσá .S╞á filσá i≤á thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠á use≤á fo≥á mergσ ì
  96. letters¼á  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼á anΣ eacΦ recorΣ i≤ ì
  97. delimiteΣ witΦ CONTROL-E.]
  98.  
  99.  
  100.  
  101.                                ==============
  102.                                |  OPTION 4: |
  103.                                ==============
  104.  
  105.                4)  Output records to dBASE III [Registered TM]
  106.  
  107.  
  108. WitΦá optioεá 4¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣá datßá filσ ì
  109. forma⌠á tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datßá impor⌠ ìèfunction«  
  110.  
  111. Oncσá yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσá outputting¼á thσ ì
  112. structurσ oµ tha⌠ filσ is:
  113.  
  114. Field  Field Name  Type       Width    Dec
  115.     1  FNAME       Character     20   <======== 3rd ID
  116.     2  LNAME       Character     20   <======== 2nd ID
  117.     3  PROSPECT    Character     40   <======== Primary ID
  118.     4  COMMENT1    Character     60  
  119.     5  COMMENT2    Character     60     
  120.  
  121. ** Total **                     201  
  122.  
  123.  
  124.