Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-20-2013, 03:00 AM
macropod's Avatar
macropod macropod is offline Contact details entered based on multiple drop down selections Windows 7 64bit Contact details entered based on multiple drop down selections Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,382
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, it is possible, but it is error-prone and inefficient. Consider, for a moment what youre asking the user to do: choose one option from anything up to 75 options every time they create a new letter, when they shouldn'e need to choose anything. For an organisation with five divisions, the overhead in maintaining separate templates for each business division and branch is trivial.

Indeed, it could be managed via a single template that simply references the division/branch-specific data in an external file (eg via an INCLUDETEXT field), with a macro to unlink the data as each new letter is created. That means only the data file for each business division and branch needs to be maintained.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Contact details entered based on multiple drop down selections Dynamically changing drop-down list based on selection? (Word Form) laurarem Word 1 02-21-2013 10:17 PM
ppt slides with adjustable graphs based on drop down psrs0810 PowerPoint 0 01-30-2013 07:10 AM
Outlook, Excel or Access to mange contact details? davesp Outlook 0 01-24-2013 09:47 AM
Hide contact details AndyKC Outlook 0 01-25-2010 11:00 PM
Entering Contact details GemmaD Outlook 0 12-18-2008 06:41 AM

Other Forums: Access Forums

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