I have a 2010 Excel spreadsheet named Attorney Information, which is my database and I’ve attached for your review. I also have a 2010 Word Setting Sheet document, which I’ve also attached for your review. I use the Setting Sheet to schedule prehearing or settlement conferences all during the day and I keep my Attorney Information spreadsheet open so that I can update it as well as pull phone numbers and email addresses to use on the Setting Sheet. What I’d like to do, if possible, is when I type an attorney name in the (CATY) Atty Name form field and (RATY) Atty’s Name form field, that attorney information will automatically populate into the Word document, based on the attorney name. So the Word Phone # form field will be the attorney phone number. If the attorney has an extension number, that will populate into the Contact # form filed on the Word document. And the email for that attorney will populate into the CATY Email and RATY Email form fields. Like I said, all of this attorney information is stored on the Excel spreadsheet.
Thank you.
Pamela Ballard