Auto Populate Letterhead addresses

I am trying to create a standard template for business forms (letterhead, memo, fax, transmittal etc) that prompts you to select an office address in a list and then adds it to the form. We have 23 offices and we want to standardize the forms to not incluse every address (getting long). But rather select an address pre populated and then have it insert it.

I know ther has to be a way to do this. but I am struggling.

Answer
Answer

You should put a userform in the template that contains a combobox from which the user selects the required address.  To populate that combobox with the office locations and their address details, it would be best to pull them from an Excel Workbook where it will be easy to update them as required and issue a new copy of the Workbook when necessary.

To learn how to do all of this, see the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm


http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 134 Applies to: