View Single Post
 
Old 10-26-2018, 05:36 AM
etruz etruz is offline Windows 10 Office 2007
Novice
 
Join Date: Oct 2018
Posts: 2
etruz is on a distinguished road
Default Letter Template /w combo box list

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!
Reply With Quote