Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2018, 03:43 PM
Guessed's Avatar
Guessed Guessed is offline Generate template-based letter with multiple variables Windows 10 Generate template-based letter with multiple variables Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


Are the users in-house? Macros are a great solution when the template can be distributed easily to them - not so great when the template is emailed or downloaded because the macro security can be a complicating factor.

I would explore a non-macro solution first by using linked Content Controls and put a 1 page form in front of the letter as the 'input form'. The input form can be completed, and then the user can delete that page.

To help setup the linked CCs in the file, you should use an addin template like Greg Maxey's Content Control Tools https://gregmaxey.com/word_tip_pages...rol_tools.html
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 07-10-2018, 12:57 AM
shallaes shallaes is offline Generate template-based letter with multiple variables Windows 10 Generate template-based letter with multiple variables Office 2013
Novice
Generate template-based letter with multiple variables
 
Join Date: Jul 2018
Posts: 3
shallaes is on a distinguished road
Default

Thanks for your replies.


Okay, so it's an audit report for small companies with nearly all generic text.


Some variables necessarily needs to be put in directly (company name, financial results - company specific variables that cannot be imported from anywhere).


Others will have 2-5 predefined options (organ addressed, choosing type of organization leading to words being replaced throughout the report, minor deviations in text or rearrangement of 3-4 words based on content of annual report)


Should I still go non-macro? And how hard and/or time-consuming would it be to put together what I'm looking for?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
template text selection based on input multiple choice question waba Word VBA 1 04-08-2018 02:31 PM
Generate template-based letter with multiple variables Need a formula to set a field based on two variables unknownhere2000 Excel 2 01-12-2016 01:05 PM
Generate template-based letter with multiple variables Need help with a template based letter xJennyx Word VBA 2 07-25-2014 09:00 AM
Generate individual checklists from one template pog451 Excel 0 02-04-2014 05:26 AM
Calculating a cell value based on many variables malawimick Excel 0 12-14-2011 05:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 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