From the 1st of January 2019 onwards, 15 Flemish municipalities will be combined into 7 different municipalities with a new name. If you have clients residing in one of these municipalities, this will affect your CRM database and will cause it to be outdated. In this article we'll explain what happens exactly and we will give you some pointers on how to deal with the changes.


Keep in mind this change only affects you if you have clients with Flemish addresses in your CRM! 


Which municipalities are affected?


Postal Code

Old Name

New Name

2870

Puurs

Puurs-Sint-Amands

2890

Sint-Amands

Puurs-Sint-Amands

3670

Meeuwen-Gruitrode

Oudsbergen

3660

Opglabbeek

Oudsbergen

9910

Knesselare

Aalter

9880

Aalter

Aalter

9770

Kruishoutem

Kruisem

9750

Zingem

Kruisem

9850

Nevele

Deinze

9800

Deinze

Deinze

3910

Neerpelt

Pelt

3900

Overpelt

Pelt

9930

Zomergem

Lievegem

9950

Waarschoot

Lievegem

9920

Lovendegem

Lievegem


What happens to the postal code?

Let’s take Deinze as an example, with the postal code 9800. Nevele will remain a sub-municipality of Deinze and will thus keep the postal code 9850. It’s only the name of the municipality that changes. 


What with street names and house numbers? 

The fusion of certain municipalities also affects street names and house numbers. Some street names received a new name and also some house numbers changed. More information can be found on this website, where you can find an elaborate list of which streetnames change their names. Download the .zip file ‘Fusie 2019 verschilbestand 20181220.zip


How to deal with this change in Teamleader?

  • For the new municipalities, we adapted the postal code prefill, so that if you enter a postal code, the right municipality is prefilled automatically. 

  • For your existing customers however, the old municipality name won't change automatically into the new municipality name. You’ll need to follow these instructions to update the field ‘City’ for the municipalities affected. Let’s take the municipality ‘Nevele’ as example again:

    • Create a segment on company/contact level with all companies/contacts with an address in Nevele. Use the following Rule:

    • You’ll have a segment with all companies in Nevele. You can then export this segment to Excel:

      • Don’t export all columns, but choose to create a new template for the export selecting the columns ‘Teamleader ID’, ‘City’ and 'ZIP code’



      • Download your Excel file and change the name of the 'City' to Deinze. Save the Excel file and import the file in Teamleader again. The companies will be adapted to the right municipality name. 


  • Double check if the street names and house numbers of your clients in the affected municipalities remain the same using the .zip file (Fusie 2019 verschilbestand 20181220.zip) mentioned above. If not, you'll need to manually change them in your CRM. You could also add the streetname and number to your Excel export to immediately change the streetname and number via export/import.