Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2020, 09:52 PM
Joxner Joxner is offline Adding in names across 8 document templates Windows 10 Adding in names across 8 document templates Office 2016
Novice
Adding in names across 8 document templates
 
Join Date: Jun 2020
Posts: 1
Joxner is on a distinguished road
Default Adding in names across 8 document templates

I assist in drafting Estate Documents for people and families that want an estate plan, but do not have much to leave. We typically draft about 8 documents from Word templates for each person.

At present, we send out an estate planning questionnaire to our clients. Once we receive their responses, we then copy and paste their responses (manually) into each of the document templates we have, send them to clients for review, make changes based on their comments, then once everything is good to go, we schedule the clients to come into the office and sign the documents.

On the day of signing, it is my job to insert who will be the witnesses and notary for the signing ceremony. Not all documents require the witnesses to sign, not all documents require the notary to sign, and some documents require both.

The staff that I insert into the documents as witnesses and notaries change depending on who is available that day to serve as a witness or notary. So when I learn what witnesses and notary we will have available, I have to go into each of the 8 documents and add in the names and addresses of the witnesses and notary. This usually takes me over an hour to copy and paste them all in to each of the documents, despite my best efforts.

I am wondering if there is a way to automate the adding in of the names across all 8 documents.

I am also trying to use Microsoft Forms to automate the building of the word documents from client responses. The problem is, when the templates are created, I do not know who will serve as the witnesses or notary, so I cannot insert that information until the day of signing.

I have decent computer knowledge (no coding knowledge), so if someone could point me in the right direction it would be very much appreciated.

My questions:
- Is it possible to automate the adding in of witness names and notary names across 8 documents?
- Should I be using Microsoft Power Automate to accomplish this?
- I was thinking of having the clients fill out a Microsoft Forms questionnaire, have the data exported to excel, then have excel export to my Microsoft Word templates. Then I can also have in Excel a place for my witness and notary names to export from there into the word templates.

Thank you so very much!
Reply With Quote
  #2  
Old 06-27-2020, 09:02 PM
gmayor's Avatar
gmayor gmayor is offline Adding in names across 8 document templates Windows 10 Adding in names across 8 document templates Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,216
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

Given that it appears the pool of witnesses are your own staff, and the notaries are also from a similar pool of names, it should be relatively simple to produce a macro with a userform with a list box from which to select the witnesses and a combo box to select the notary and write the selections to content controls in the 8 documents. See Create a userform


Attached is a simple template containing the required code to get you started
Attached Files
File Type: dotm Example.dotm (38.5 KB, 0 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
automation, estate

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding in names across 8 document templates Merging a Word document from two or more document templates Florre Word VBA 1 06-26-2019 03:20 PM
Adding in names across 8 document templates Adding names of users from one column to another and color change to annual cap cmgtlg Excel 6 04-28-2017 05:46 AM
Adding in names across 8 document templates Count names from another document teza2k06 Excel 5 01-09-2015 03:07 AM
Adding names to sheet for printing WV8VFD Excel 4 12-01-2013 11:02 PM
Adding company templates into Powerpoint dennisv PowerPoint 0 04-09-2012 11:39 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft