Letter Template /w combo box list

[etruz]

Hi all, this will be my first post on this forum.


I have already searched around a little bit, however I cannot find an immediate answer to my question.

For work I am trying to create a general letter template, which information (like entity name, address,...) is easily changeable thanks to selecting 1 entry in a combo box list (or drop down list). The rest of the information should automatically update.

I thought there should be an easy way to accomplish this, however so far I can't find any way.

The things that should be changeable should be:
sender entity's information (name, address, phone number, VAT, ...)
sender's information (name, title, phone, ...)

I found a VBA entry on this forum, however as soon as there's multiple text fields involded, it simply bugs.

Anyone has got any ideas?

Thanks in advance!