I do weekly surveys of HOA properties in developments. I use a lap top which contains all of homeowner contact info, while I drive I inspect for a handful of infractions and enter the infraction type to the corresponding homeowner. Currently I open one word document for each specific infraction type as all of them need a slightly different letter. Starting with infraction 'A', I merge the contact and infraction info into a word doc just for that infraction then, save, print, & close... then repeat that for infraction 'B', 'C', 'D', 'E' etc... It's pretty time consuming as each development also needs different varieties of these letters... Is there a way to make excel choose the specific infraction word document to merge into, so that I can run all of the letter varieties at once?
Bookmarks