Outlook 2010 – Migrate Autocomplete Settings
Nov17

Outlook 2010 – Migrate Autocomplete Settings

KB ID 0000451  Problem Before Outlook 2010 we could simply migrate autocomplete entries by locating and moving the clients nk2 file. But Outlook 2010 did away with the .nk2 autocomplete file. The autocomplete/autosuggest file remembers your previously typed email addresses. The good news is that you can still migrate the settings, only now you need to migrate a .dat file instead. Solution 1. In this example I’ll migrate the...

Read More
Excel – IP Address Formula for ‘Auto fill’
Nov17

Excel – IP Address Formula for ‘Auto fill’

KB ID 0000928  Problem I got asked this week if I know how to do this, a colleague was doing a spreadsheet, and needed to quickly put in IP addresses. The Problem is if you use ‘Auto Fill’ to continue your IP addresses, it does not behave quite like you would expect. Solution A quick search got me most of the way there, but the solution is different depending on which ‘octet’ of the IP address you want to...

Read More