View Single Post
 
Old 03-23-2018, 05:33 AM
ajb ajb is offline Windows 8 Office 2016
Novice
 
Join Date: Mar 2018
Posts: 4
ajb is on a distinguished road
Question Preparing a drop down with options to complete multiple fields

Hi all,

I am looking for some help. I want to create a letter template that has a 'signature' sign off at the bottom. At our firm we have 10+ employees, each with different contact information.

Say we have Bob and Joe. Both Bob and Joe use the same letter template, but I want the signature section of the letter to have a dropdown two options for their names only. Then, based on the option the user picks, the signature section will fill with their respective information.

The format is as per this image



Is someone able to help me in this? I know the dropdown can be used for a sole text selection but what about running a Macro?

Would appreciate any help.
Attached Images
File Type: png Dropodown.png (29.8 KB, 24 views)
Reply With Quote