Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
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
 



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 05:55 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