Share Gallery 1/share_gal_1.zip/share_gal_1/BF/BF025A.ZIP/SALE-A30.ZIP/MERGE.DOC

Text File | 1990-01-16 | 11KB | 258 lines

ááá
                          Import or Output Data:

                                  Import:
              Import an 11 field ASCII "commß delimitedó file.
                              see option '8'

                                  Output:
    WordStar[TM]/MailMerge[TM]/WordPerfect[TM]/Microsoft [TM] Word 4.0
              dBASE III [TM]/SBT [TM]/SourceMate [TM] Output
                       Basica/Output Sequential File

                                 Overview:
                               Options 1 - 7

Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼á WordPerfect[TM]¼á o≥ ì
dBAS┼á II╔ [TM▌ datß filσ usinτ thσ datß froφ you≥ Prospect/dBAS┼ II╔ file« ì
Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ .DEF'¼ '.SFº o≥ '.DBF'.

Iµ useΣ witΦ Wordstar[TM]¼á thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφá letter≤ ì
iεá MailMerge[TM]«á  Al∞ characte≥ field≤ arσ  trimmeΣ oµ trailinτ blank≤ t∩ ì
accommodatσá you≥ forφ letters«á   Alonτ witΦ thi≤ datß file¼á thσá Wordsta≥  ì
optioεá create≤á thσ beginninτ oµ  you≥ forφ lette≥ anΣ put≤ i⌠á iεá ßá filσ ì
endinτá iεá thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌á command≤ ì
yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)«

Iµá useΣá witΦ WordPerfect[TM]¼á thσ .S╞ filσ i≤ thσ 'Secondar∙á Fileºá tha⌠  ì
WordPerfec⌠á use≤á fo≥ mergσ letters¼á  wherσ eacΦ fielΣ i≤á delimiteΣá witΦ ì
CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]

Iµ useΣ witΦ dBAS┼ II╔ [TM]¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣ ì
datßá filσá forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á thei≥á respectivσ ì
datß impor⌠ function.

Wheε useΣ witΦ Microsof⌠ [Reg«á TM▌ WorΣ 4.0¼á thσ '.DATº filσ contain≤ thσ ì
datß o≥ record≤ tha⌠ thσ WorΣ 4.░ mergσ documen⌠ requires«



Thesσ option≤  wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iε you≥ prospec⌠ filσ ì
t∩ aε externa∞ tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣ b∙ ß worΣ processo≥ t∩ ì
creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.

BaseΣá oε you≥ selectioε criteria¼á iµ any¼á thσ prograφ wil∞á outpu⌠á thesσ ì
fields║
     Se° ID¼ Firs⌠ name¼ Greeting, Las⌠ name¼ Compan∙ Name¼ Address1/2
              City¼ State¼ Zip, Zip4¼ Phonσ number¼ Comment≤


                               ==============
                               |  OPTION 1: |
                               ==============

                             Selection Process:
èA⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥
you≥ worΣ processo≥ mergσ file║

             Las⌠ Name¼ Firs⌠ Name¼ Company¼ City¼ State¼ Zip,
                               anΣ Comments.

Yo⌡á caεá selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩  bσ  selecteΣá  tha⌠  ì
havσá al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠  record≤á regardles≤á oµ ì
thσá numbe≥ oµ  matche≤ madσ pe≥ record¼á  a≤ lonτ a≤ a⌠  leas⌠ onσ matcΦ i≤ ì
madσ iε an∙ onσ recorΣ tha⌠ i≤ selected.

Truσ  [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠  t∩
bσ  selected«   Falsσ  [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε  ß
recorΣ i⌠ wil∞ bσ selected.



                         Search Criteria Selection:
                                 Option 1:

Yo⌡ caε ente≥ an∙ word¼á  phrase¼  o≥ codσ oε whicΦ t∩  basσ you≥ selection«  ì
Iµá lef⌠ blank¼á  al∞ record≤ wil∞ bσ selecteΣ out«á   Iµ yo⌡ makσ aεá entr∙ ì
here¼á  thσá prograφ wil∞ searcΦ througΦ thσ prospec⌠ filσ  anΣ  selec⌠á ou⌠ ì
onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.

[Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσá anΣ ì
al∞á  record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ  o≥ an∙  combinatioε ì
oµ them]

                               ==============
                               |  OPTION 2: |
                               ==============
                2)  Output records to Wordstar/Mailmerge[TM]
              [outputs into a 12 field, comma delimited file]

                             fields outputted:
             SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
                 ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE-1

Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Prospec⌠ filσ anΣ outpu⌠ i⌠á t∩á ß ì
filσá tha⌠á caε bσ useΣ b∙ WordStar/MailMerge[TM]«á  Thi≤  filσ caε als∩á bσ ì
useΣ b∙ BASI├ anΣ othe≥ language≤ anΣ products«á Iε short¼á an∙ produc⌠ tha⌠ ì
accept≤á "commß delimitedó file≤ fo≥ inpu⌠ ma∙ accep⌠ thσ  filσá createΣá b∙ ì
thi≤ option.

Froφ thσ WordSta≥ option¼á yo⌡ wil∞ creatσ  tw∩ files«á  Thσ firs⌠ filσ namσ ì
end≤á iεá .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ß forφ lette≥á jus⌠á b∙ ì
callinτá i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφ letter«á  I⌠ alread∙ ì
contain≤á al∞ oµ thσ command≤ needeΣ b∙ WordSta≥ t∩ reaΣ thσá Prospect/dBAS┼ ì
II╔ datß filσ (.DAT).

Thσ othe≥  filσ i≤ thσ .DA╘ file¼á whicΦ contain≤ al∞ datß tha⌠ yo⌡ wan⌠á t∩ ì
reaΣá int∩ WordStar«á  I⌠ i≤ formatteΣ sequentia∞ file¼á witΦ al∞ field≤á iε ì
quote≤ anΣ separateΣ b∙ commas«
è
                               ==============
                               ⁿ  OPTIO╬ 3║ |
                               ==============

                   3)  Output records to WordPerfect[TM]
            [outputs into a 14 field, CONTROL-R delimited file]

                             fields outputted:
      SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
                    ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2

Thσá .S╞á filσá i≤á thσ 'Secondar∙ Fileº tha⌠  WordPerfec⌠á use≤á fo≥á mergσ ì
letters¼á  wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼á anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]

Bσá surσ t∩ retrievσ thσ 'Secondar∙ Fileº int∩ WordPerfect¼á a⌠ whicΦá timσ ì
WordPerfec⌠ wil∞ inser⌠ it≤ printe≥ codes«  Then¼ whilσ insidσ WordPerfect¼ ì
savσ thσ filσ unde≥ tha⌠ samσ name«á  A⌠ thi≤ point¼á thσ 'Secondar∙á Fileº ì
wil∞ bσ usablσ fo≥ purpose≤ oµ mai∞ merging.



                               ==============
                               |  OPTION 4: |
                               ==============

               4)  Output records to dBASE III [Registered TM]


WitΦá optioεá 4¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣá datßá filσ ì
forma⌠á tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datßá impor⌠ ì
function«

Oncσá yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσá outputting¼á thσ ì
structurσ oµ tha⌠ filσ is:

Field  Field Name  Type       Width    Dec
    1  SEX         Character     19
    2  FNAME       Character     20
    3  GREETING    Character     20
    4  LNAME       Character     20
    5  PROSPECT    Character     40
    6  ADDRESS1    Character     30
    7  ADDRESS2    Character     30
    8  CITY        Character     30
    9  STATE       Character      2
   10  ZIP         Numeric        5
   11  ZIP4        Numeric       4
   12  PHONE_1     Character     13
   13  COMMENT1    Character     60
   14  COMMENT2    Character     60

** Total **                     354
è

                               ==============
                               |  OPTION 5: |
                               ==============
               5)  Output records to Microsoft [TM] Word 4.0

              [outputs into a 12 field, comma delimited file]

                             fields outputted:
             SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
                 ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE1


Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Prospec⌠ filσ anΣ outpu⌠ i⌠ t∩á ß ì
datß filσ tha⌠ caε bσ useΣ b∙ thσ mergσ featurσ iε WorΣ 4.0..

You≥ WorΣ 4.░ lette≥ wil∞ contaiε mergσ variable≤ oµ thσ form:

                                  <<SEX>>
                                 <<FNAME>>
                               <<GREETING>>
                                 <<LNAME>>
                               <<PROSPECT>>

anΣá s∩ on«á  Thesσ mergσ variable≤ arσ identifieΣ iε thσ '.DEFº o≥á heade≥ ì
filσ createΣ b∙ thσ program«á  Thesσ symbols¼á "<<ó anΣ ">>"¼ arσ formeΣ b∙ ì
holdinτ dowε thσ <ALT╛ ke∙ anΣ typinτ 17┤ o≥ 175.


A⌠á thσá to≡ oµ you≥ WorΣ 4.░ letter¼á yo⌡ wil∞ havσ thi≤ commanΣá (iµá yo⌡ ì
selec⌠ 'TESTº a≤ thσ filσ namσ fo≥ outputtinτ you≥ datß iε optioε 5):

<<DATA TEST.DEF, TEST.DAT>>

Thi≤á tell≤ WorΣ 4.░ t∩ looδ int∩ TEST.DE╞ fo≥ thσ heade≥ o≥ identificatioε ì
oµ field≤ used╗ anΣ t∩ pul∞ iε TEST.DA╘ fo≥ thσ data.

TEST.DA╘ i≤ ß 'commß delimited¼ ASCI╔ file'«  I⌠ contain≤ al∞ datß tha⌠ yo⌡ ì
wan⌠á t∩ reaΣ int∩ WorΣ 4.0«á  I⌠ i≤ formatteΣ sequentia∞á file¼á witΦá al∞ ì
field≤ iε quote≤ anΣ separateΣ b∙ commas«


                               ==============
                               |  OPTION 6: |
                               ==============

This option will append records directly to the SBT [TM] customer file.


                               ==============
                               |  OPTION 7: |
                               ==============

Thi≤á optioεá wil∞ appenΣ record≤ directl∙ t∩ thσ SourceMatσ [TM▌á custome≥ ìèfile.

                               ==============
                               |  OPTION 8: |
                               ==============

                        Import data from ASCII file:

áááCreatσ aε ASCI╔ "commß delimitedó filσ witΦ thesσ 12 fields:

áááFirs⌠ namσ     <=╜ u≡ t∩ 2░ characters
áááLas⌠ namσ      <=╜ u≡ t∩ 2░ characters
áááCompan∙ namσ   <=╜ u≡ t∩ 4░ characters
áááAddres≤ ▒      <=╜ u≡ t∩ 3░ characters¼ firs⌠ linσ oµ addres≤
áááAddres≤ ▓á     <=╜ u≡ t∩ 3░ characters¼á2nΣ line¼áiµ any¼ásucΦáa≤
                   ááá'Suitσ 214'
áááCit∙           <=╜ u≡ t∩ 3░ characters
áááStatσ          <=╜ tw∩ characte≥ state¼ iµ U.S.A.╗ elsσ leavσ blank
áááZi≡            <=╜ U.S.A« Zi≡ code¼ ╡ characters
áááZi≡4           <=╜ U.S.A« Supplemental Zi≡ code¼ 4 characters
áááPhonσ          <=╜ 1│ character¼ iµ .U.S.A« o≥ Canada« Mus⌠ be
                      in this form:  [phone]
                      Observe character 1 is '(', 5 is ')', and 9 is '-'
áááComment1       <== any comment, up to 60 characters
   Sex ID         <== if used, such as 'Dr.', 'Captain', or 'Reverend'

áááOptioεá ╕ wil∞ impor⌠ froφ aε ASCI╔ filσá named║á 'AIMPORT.TXT'«á  Makσ ì
ááásurσ tha⌠ you≥ filσ ha≤ tha⌠ name«á  Oncσ Optioε ╣ i≤ complete¼á g∩á t∩ ì
áááthσáá Othe≥á Option≤á Menu¼áá anΣá selec⌠á Optioεá ╣á froφá tha⌠á menu║ ì
áááRepack/Reinde° records.

áááObservσ belo≈ onσ recorΣ iε thσ ASCI╔ "commß delimitedó format:


   "John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
      "Suite 101","Dallas","TX","75229","0234","[phone]","SIC=4303",""


áááObservσá tha⌠á "Suitσá 101ó  woulΣ normall∙ follo≈ afte≥á "1105╢á Shad∙ ì
áááTrailóá oεá onσ continuou≤ line«á  Herσ thσ recorΣ i≤ brokeεá int∩á tw∩ ì
áááline≤ onl∙ fo≥ purpose≤ oµ showinτ yo⌡ ho≈ i⌠ looks.