View Single Post
 
Old 04-02-2018, 09:42 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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

It sounds like you only need one drop down box and the other three can then be plain text CCs filled from some information source. The trick is deciding where to store the company name, address and phone number.

Do you have a table that lists the relevant information somewhere:
Manager; Company; Address; Phone

A non-coded method would be to store each of the variable information blocks in a particular building block Gallery and Category and then use a Building Block content control to allow the user to select one to insert all at once. This is actually pretty easy to set up and far easier than trying to solve it with a macro.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote