Attorney Mailing List

The employee will do the following: go to [login to view URL] type in "divorce attorney" for "Austin, TX" approximately 161 results will be returned. DELIVERABLE #1: Cut-and-paste each entry into a spreadsheet. One entry per line. "Law Office Name", "Address Line 1", Address Line 2", "City", "State", "Zipcode", "Phone Number", "Fax Number", "Email", etc. Note: if fax is not given, leave entry blank, same with email address. go to [login to view URL] type in "estate attorney" for "Austin, TX" approximately 236 results will be returned. DELIVERABLE #2: Cut-and-paste each entry into another spreadsheet tab (same workbook as above). One entry per line. "Law Office Name", "Address Line 1", Address Line 2", "City", "State", "Zipcode", "Phone Number", "Fax Number", "Email", etc. Note: if fax is not given, leave entry blank, same with email address. DELIVERABLE #3: In a third tab of the same workbook above, condense the two other tabs into a third worksheet. In other words, remove the duplicate entries (since some law offices practice both divorce and estate law). DELIVERABLE #4: Take the third worksheet above and produce a Word doc that uses the Avery #5160 template. Thereby creating a printable label document of the condensed list of attorneys.