ࡱ;   !Root Entry F@CompObjbWordDocument6ObjectPool  FMicrosoft Word 6.0 Document MSWordDocWord.Document.6;  Oh+'0 ( L p $ HlC:\WINWORD\TEMPLATE\bee.dotAddress Program Help File Jody Dillow Jody Dillow@ͳ@ܥe3 e6'  33333444444 445C*4*4@4@4@4@4@4@4d4f4f4f44556TW6^53@4 @4@4@4@45@433@4*4@4@4@4@43@43@4d433"3333@4d4@4$@4Address Program Help File 7 Jan 95 Before you Begin Copy merge.dot, mergeenv.dot and bee.dot to your winword template directory. Enter your WinWord paths. Add the WinWord Macros Address Menu Screen Enter Data Click this to open the address list main form and enter your data. Important! When the program is first opened and you have not created your own address list yet, it may assume that ADD_DAT.LST (or some other database) is your address list and that this database is in the c:\access directory. If it is not, you will get an error. To fix it, just follow the screen directions and enter the name of an existing address list or create your own new database list (which is probably what you will want to do). Address list files must have the extension *.LST. Also, if you delete your current database files and then try to open the program, you will get this same error - it is looking for the files you deleted and cant find them. Enter Address List Enter the name of your address list database. E.g. jddat.lst. If it is not in the same directory as address.mdb, you need to enter the full path. If you enter a name that does not exist, you will get an error and be returned to the screen. Address list files must have the extension *.LST. Set Winword Paths The programs assumes that your winword directory is c:\winword. If this is not so, then you must tell it where to find winword and where your letters directory is. It could be c:\winword or c:\winword\letters or c:\msoffice\winword\letters or whatever you want. Also, you must copy bee.dot and merge.dot to you template directory before you can use the mail merge or Add WinWord Macros. Add WinWord Macros In order for the mail merge feature to work, the merge macro must be in your normal.dot file. If you click this button, the program will walk you through the process. The merge macro is stored in BEE.DOT and must be copied to NORMAL.DOT. Create New Database Probably you do not want to use ADD_DAT.LST as your database. So enter your own. If you want to store your data in another directory besides the directory in which your program, address.mdb, is located, then enter the full path. Address list files must have the extension *.LST. Find and Sorting Records The program assumes you have the Form View tool bar open. If you do not, click view, and toolbars, and Form View. You can sort by putting the cursor on the field you want to sort by and then click records and quick sort. To find, put the cursor on the field you want to search on and click on the binoculars on the tool bar, the find icon. Or you can do a more complex find by clicking on the search button. Mail Merge When you click this option in the search form, you address.mdb exports the files you have selected with Find to your winword\letters directory and executes a macro in normal.dot called merge which opens a mail merge letter and attaches the data source. The data source is a file called merge.txt located in your winword\letters directory. From that point on, follow the WinWord 6 mail merge procedures. I usually merge to a document, and then edit, personalize, and print the document. Envelopes Clicking on the Envelope button will print the currently selected envelope. It assumes you are using #10 - 4 1/8 x 9 1/2. If you are using a different size, you will need to modify the rptenvelope according the instructions in the Access Manual on reports. To mail merge your entire list and create envelopes, just do a mail merge on the selected data for your letter mail merge as above then. Do this: 1. Open a the template called mergeenv.dot in winword\template directory. 2. Print the mail merge to a document (or your could do this directly and print to printer.) 3. Print the document Wizard Clicking this will export your data to the program OLE.EXE sold by Sharp which in turn will export your data to the Wizard OZ 9500. You must purchase this from Sharp. If you have OL2.EXE for the IQ 8000, or need some other export format, some modification would have to be made to the export procedure. If you know Access basic you could modify the Event Procedure cmdWizard_Click() attached to the Wizard button. Zero Code 1 The Code 1 field is intended for random marking of various records for selection for mail merge or labels, etc. In order to clear out all these random codes and start over, clicking this will insert one blank space in every Code 1 field and set the field to a blank. Update Notes Clicking this button will bring up a dialogue box in which you can enter up to 255 characters to summarize a mass update of all records selected by clicking the Find button. For example you may have sent a mailmerge letter to 75 people and you want a record of who you sent it to. So you would enter something like Sent thank your note on 7/1/94 for attending the conference Update will insert this line as the first line in every selected notes field. Labels The program assumes you are using Avery #5160 3 x 10 labels. If you want to change this you would have to modify the two reports, rptLabels, and rptLabels_Main. Clicking the Label button in the main form will print a complete list in zip order. Clicking the label button in Search, will print a list of those labels selected by Find. If You Need Help Contact me at 73512,1645 Jody Dillow Address List Help Page  PAGE 3 `.A ࡱ; SummaryInformation(@w)b0@0Microsoft Word 6.013uPZ uDPZU #4  d o ZdfB\htKRE#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.E#.>,E#.E#.E#.E#.+!(#{K*`*Normalxa c0`b0 Heading 1  U]c k0`b0 Heading 2  V]ck0`b0 Heading 3xPU]k*`b* Heading 4 xPUVk*`b* Heading 5 xPU]k,`b, Heading 6 xP UV]k(`b( Heading 7 P<Uk*`b* Heading 8 P<UVk* `b* Heading 9 P<UVk"A`"Default Paragraph FontO wfxRecipientO wfxFaxNumOwfxDateO"wfxTime$'`1$Annotation Referencec2`B2Annotation TextE$.oaR.Block Quotation VB`b Body Text*oQR*Block Quotation Firstx(oQb(Block Quotation Last$C`a$Body Text Indenth oa Body Text Keep$"`b$CaptionxVc0o0 Chapter Label h U]^k<ob<Chapter Subtitlehh V]ck4oa4 Chapter Title X U]c koaDateU.o.Document Label hUc$koEmphasisV *` Endnote Referenceh2+`22 Endnote Text#E$c" `B"Footer$!oAR Footer Even%$oAb$ Footer First &!$oAr$ Footer Odd '4o4 Footnote Base(E$c &` Footnote Referenceh` Footnote Text*`Header+V(o( Header Base,!o Header Even-$o$ Header First .!$o$ Header Odd /.ob. Heading Base0 U]c$k& `&Index 110x & `"&Index 2280x & `2&Index 330x & `B&Index 440x &`R&Index 55p0x &`b&Index 660x &`r&Index 77p0x &`&Index 88 0x &`&Index 99@ 0x (o( Index Base:0x 0!`0 Index Heading;x U]ck o Lead-in EmphasisUV(` Line Number]c$/`a$List>0P2`List 2?3`List 3@p"4`"List 4A"5`""List 5Bpp^0`2^ List BulletCC  4 X6`1BX List Bullet 2;D8 4hX7`1RX List Bullet 3;E 4hX8`1bX List Bullet 4;F 4hX9`1rX List Bullet 5;Gp 4h&o12&List Bullet FirstHP$o1b$List Bullet LastI`D`` List ContinueCJ  4h.$E`$List Continue 2K8$F`$List Continue 3L$G`$List Continue 4M$H`$List Continue 5Npo List FirstOPob List LastP^1`^ List NumberCQ  4h.":`"" List Number 2R8";`2" List Number 3S"<`B" List Number 4T"=`R" List Number 5Up&o&List Number FirstVP$ob$List Number LastW-`a Macro TextX]:I`a:Message HeaderY@ 8H@@])` Page NumberU*o* Part Label [XU^c2ob2 Part Subtitle \h V]c k o Part Title]XoaPicture^*o*Section Heading_xc&ob& Section Label `h&J`!b&SubtitleaUVc">`""Title bhc(4ob4Subtitle Cover c V]c$koA Superscripteh2,`R2Table of Authoritieseh!J.#`b.Table of Figuresf0!J(o2( Title Cover gc0.`R TOA Headingh*`*TOC 1i!JU](`(TOC 2jhx!JU&`&TOC 3k!J&`&TOC 4l8!JV$`$TOC 5m!J ` TOC 6 n!J ` TOC 7 op!J ` TOC 8 p !J ` TOC 9 q@ !J o" TOC Base r!J&oab& Quotation sxVoaBGreetingtoaRIndent5uoabIndent10voarIndent15wpoaIndent20x@ *oa*Body Text Not Justifiedy4oab4Bold Center Arial 12 ptzU]  !! t- $&) !)!$ Jody DillowC:\ACCESS\ADDHELP.DOC@HP LaserJet IIPLPT1:HPPCLHP LaserJet IIP  DLg .,,"D3dHP LaserJet IIP  DLg .,,"D3d CTimes New Roman Symbol &Arial5Courier New"AV h_: 60$#^C:\WINWORD\TEMPLATE\bee.dotAddress Program Help File Jody Dillow Jody Dillowࡱ;