Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2015, 08:54 AM
daj daj is offline Method for populating report text from a library of text. Windows 7 32bit Method for populating report text from a library of text. Office 2013
Novice
Method for populating report text from a library of text.
 
Join Date: Mar 2015
Posts: 1
daj is on a distinguished road
Post Method for populating report text from a library of text.

We currently use several basic report templates. The current method of creating reports is rather brute force. If a report section has 5 different options of text (each of which might be several paragraphs) we have all 5 options populated in the template. We just delete whatever text is not needed (i.e. delete 4 of the 5 options).

We are in the process of revising all templates, etc. to Word 2013 (removing the backwards compatibility). As part of this, we are looking for a way to more efficiently 1) develop a new template and 2) populate needed text.

We know we can use Quick Parts/Auto Text to do this, but the Auto Text list would get rather long and the text is somewhat hard to see (leading to errors in inserting the wrong text).



Ideally, we would have a document which is a library of all optional language in which we could somehow mark which text should be inserted, and have it automatically placed in the report, but I know of no way to do this.

Any ideas would be appreciated.
Reply With Quote
  #2  
Old 03-18-2015, 08:57 AM
Charles Kenyon Charles Kenyon is offline Method for populating report text from a library of text. Windows 7 64bit Method for populating report text from a library of text. Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,461
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

Create & Employ a Userform
Create a Simple Userform
AutoTextList field - How to add pop-up lists to any Word document, so you can click your way through changes in seconds
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Method for populating report text from a library of text. Looking for Assistance to Perfect my Inspection Report Functionality - Auto Inserting Text, etc. 360Inspect Word VBA 2 02-01-2015 07:16 AM
Reapting/Populating the same text in Word 2007 akwjaw14 Word 0 06-03-2014 03:40 PM
VBA to word-wrap text in a Custom Report OTPM Project 2 03-08-2013 09:12 AM
Method for populating report text from a library of text. Read text Report file with VBA and write parsed fields to Excel workbook tpcervelo Excel Programming 1 01-05-2012 10:14 PM
Method for populating report text from a library of text. Populating ComboBox or Drop Down list with contents of a text field Billy_McSkintos Word VBA 1 09-13-2011 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 PM.


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