Hello Excel Experts,

I know how to open a Word dcument from Excel VBA, however I am really hard time trying to achieve the following:

I already have a Userform with a Combobox, where the list of Options to choose are in column A. Options are different Company Locations (Manchester, Liverpool, Scotland...).

What I still dont know how to do and I ask for your help is the following:

I want to "link" each Option in Column A with a specific Word Document, so when that Option is Chosen, its corresponding Word Document will be opened. This is because evey Word Document is a differnt Format of a letter that Needs to be sent.

Can anyone help me with this?

Thank you ver much in advance!

Jorge