Thread: [Solved] Contact details entered based on multiple drop down selections
View Single Post
 
Old 04-20-2013, 03:00 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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