All of the files related to the Directories are contained in a folder named RetamaDirectory. The photos used in the Resident Photo Directory are stored in a folder called ResidentsPhotos kept inside the RetamaDirectory folder.  The information for the Retama Directories is maintained in a Microsoft ACCESS database called Retama4.

1. In the MS ACCESS database, run the ExportSpreadsheets Macro..
2. In MS WORD, run the Generate Inserts macro in ProcessGenerateInserts.docm
3. Ignore warning about error.
4. Click on YES to SQL warnings when they appear, say No to save Template files.
5. In MS PUBLISHER, open RetamaDirectoryPhotos.pub
6. Scroll down to the first page of the Name Order list
7. In the list, Ctrl-A to select the whole Name Order list, then hit the Delete Key
8. In MS WORD go to InsertResidentPhotos, Ctrl-A to select whole document, then Ctrl-C to copy the highlighted area.
9. In MS PUBLISHER, click inside the first Name Order List box, then Ctrl-V to paste copied document.
10. Insert page if needed
11. Back in MS PUBLISHER, scroll down to the first page of the Address Order list.
12. In the list, Ctrl-A to select the whole Address Order list, then hit the Delete Key
13. In MS WORD go to the InsertResidentsAddressOpen.docx,  Ctrl-A to select whole document, then Ctrl-C to copy the highlighted area
14. In MS PUBLISHER, click inside the first Address Order List box, then Ctrl-V to paste copied document
15. Review the Address Order List looking for couples that are split by end of columns..  Add Enters to move the couples together.
16. Review the Street Order list looking to insure both members at an address (if two) are together.  Use Enters to adjust.
17.  At the end, insure the Page nn of nn is equal.  If a page has been added or deleted, adjust the "of nn" by clicking on Insert from the top tabs, then Footer in the Ribbon and edit.  Then click on Close Master Page.
18. Print the ResidentsDirectory.pub into a PDF file.
19. If Adobe asks about the photo links, navigate to the first document photo in the PhotoDirectory folder in the RetamaDirectory folder, highlight the first photo in the pub (could be name or PN).  
20. When Adobe asks if the same redirect should be used for the rest of the photos, answer yes,
21. When Adobe Acrobat, offers the file name as ResidentsDirectory.pub, change the file name by adding the timestamp (_yyyy_mm_dd) at the end (ex: ResidentsDirectory_2020_12_10a).  The "a" at the end is important for the next step.
22. When the PDF file is completed and displayed in Adobe Acrobat, Select File / Save as Other / Reduced Size PDF...
23. Answer YES to the popup, then when the file save box appears, remove the "a" from the file name end.
24. Save the MS PUBLISHER document and then Print it using PDF as the format adding _yyyy_mm_dd (Ex: _2020_03_27) to the end of the file name before the PDF
25. Close MS PUBLISHER and the two MS WORD documents without saving. 
26. Repeat steps 4-23 using RetamaOwnersDirectory.pub using InsertOwners.docx and InsertOwnersAddress.docx including the reduce the PDF file size, the "a" in steps 20-22.Repeat steps 4-23 using RetamaDirectory.pub using InsertResidents.docx and InsertResidentsAddress.docx.
27. inside the Street Order list, Ctrl-A to select the whole list and hit the Delete Key
28. Inside the Street Order list, click and then Ctrl-V to paste the copied document

Then upload the directory PDFs.