Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2015, 01:19 PM
JMattero JMattero is offline Automate entering variable info into a lease document Windows 7 32bit Automate entering variable info into a lease document Office 2010 32bit
Novice
Automate entering variable info into a lease document
 
Join Date: May 2015
Posts: 2
JMattero is on a distinguished road
Default Automate entering variable info into a lease document

Hello:
I have rental properties. When a new tenant is approved I have to fill out a lease document, and mine is 13 pages long. 95% of the information on this lease document is static. The only things that change on each lease are items such as Tenant name(s), property address, rental amount, etc.

I would like to have a way of doing the following... When I click to open the lease, a form would come up in which I would enter the changing information only. Then, that form would populate the lease document.

To be a little clearer, along with the lease, there are 5 or 6 other documents that I give to the tenant. The same information (tenant name(s), property address, etc) are also required on each of those associated documents.

I am thinking I can create one long "Move-in package" of documents which would contain all of the various "sub-documents" (lease, helpful phone numbers, move out charges, etc). Then, that form that I fill in would populate all of these various documents with the repetitive information.

I am NOT a programmer, and I have never used VB. Is there any way to accomplish this?

Thanks in advance.
Reply With Quote
  #2  
Old 05-28-2015, 06:23 PM
Mandy11 Mandy11 is offline Automate entering variable info into a lease document Windows 7 64bit Automate entering variable info into a lease document Office 2003
Novice
 
Join Date: May 2015
Posts: 18
Mandy11 is on a distinguished road
Default

A mail merge should accomplish everything you are trying to do.
Reply With Quote
  #3  
Old 05-28-2015, 07:38 PM
JMattero JMattero is offline Automate entering variable info into a lease document Windows 7 32bit Automate entering variable info into a lease document Office 2010 32bit
Novice
Automate entering variable info into a lease document
 
Join Date: May 2015
Posts: 2
JMattero is on a distinguished road
Default

Quote:
Originally Posted by Mandy11 View Post
A mail merge should accomplish everything you are trying to do.
Mandy - please explain. I have done a mail merge before for a form letter I sent to absentee landlords to see if they wished to sell their properties. That entailed creating an Excel document with the names and address of the owners, and a form letter with fields in it. I merged the two documents and Word looked to the Excel document to populate the letter.

In this case, I want to bring up the lease and associated documents, and have a window pop up asking me to fill in the Tenant Name, Property Address, rent amount, date of lease, etc. If I can accomplish that in a mail merge, please direct me on how to do it.

Thanks.
Reply With Quote
  #4  
Old 05-28-2015, 07:45 PM
Mandy11 Mandy11 is offline Automate entering variable info into a lease document Windows 7 64bit Automate entering variable info into a lease document Office 2003
Novice
 
Join Date: May 2015
Posts: 18
Mandy11 is on a distinguished road
Default

You would have to fill out the excel spreadsheet with the information and then it will populate all of your documents.
Reply With Quote
  #5  
Old 05-29-2015, 06:49 PM
Charles Kenyon Charles Kenyon is online now Automate entering variable info into a lease document Windows 8 Automate entering variable info into a lease document Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Otherwise, if you only want the information for one document, you could use a UserForm.

Create a Simple Userform
Create & Employ a Userform
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
automate macro for merged document (after merge) eibst Word VBA 1 06-05-2015 11:36 PM
Automate entering variable info into a lease document Entering new text in different color in an existing document davidbish79 Word 4 03-03-2015 12:58 AM
Can I type info in once and have it appear later in a document? nconley Word 2 12-16-2014 11:37 AM
Automate entering variable info into a lease document Automate document properties Ted C Word VBA 11 08-04-2014 06:31 AM
Automate entering variable info into a lease document Hidden Info in Document freschij Word 1 06-11-2010 12:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 AM.


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