I can’t believe I seem to be the only person on the web to work this one out, but here’s how you export and import email account settings between profiles – for which there is no option within Outlook itself.

First of all, open regedit32.exe from the search box in the start menu.

Then, navigate to this key:

[HKEY_USERS\S-1-5-21-xxxxxxxx-xxxxxxxx-xxxxxxxx-xxxx\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\

This should be showing a list of the mail profiles you have on your machine:

Navigate slightly further down the tree this time, to the key labelled:

<Profile Name>\9375CFF0413111d3B88A00104B2A6676\

This is the key that stores a list of all the email accounts in your Outlook profile:

To transfer these accounts to a different profile, or a different machine, do the following:

1. export the registry branch 9375… to a new .reg file
2. open the new file in a text editor
3. do a find and replace for /<Profile Name>/ substituting the text between the slashes with your new profile name
4. save the reg file
5. double-click on the reg file to import it into the registry

If you did everything correctly, and the named profile exists, when you reopen Outlook, and go to Tools > Account settings… you should see your newly imported accounts:

It really does appear to be as simple as that. Yay

UPDATE: jQuery Deconstructed is now JS Libs Deconstructed, also supporting Prototype, and soon, MooTools.

I’ve been interested in the internal structure of jQuery for as long as I can remember, but it can be overwhelming at the best of times, so I’ve recently made-good on my plan to build an interactive breakdown of the physical code.

Essentially, it provides a rather handy birds-eye view of the jQuery library, making it easy to dig into and understand the coding behind the seemingly-simple syntax.

Points of note:

• It breaks the physical JavaScript into visual blocks that you can easiliy navigate.
• Each block opens to reveal its internal code
• Clickable hyperlinks allow you to follow program flow

It now also has a few nice features such as:

• Live links to the online documentation
• Color themes
• Optional icons

Check it out here: http://www.keyframesandcode.com/resources/javascript/deconstructed/

I often need to save text from Excel to use with PHP, but I find Excel’s “Save As” functionality less that useful, as it converts your open worksheet to a text, which is a real pain.

This macro exports the current worksheet as a tab-delimited or comma-delimited text file, with the following features:

• optionally exports the current selection
• outputs values as text
• strips leading and trailing whitespace
• quotes any cells with spaces (TSV only)
• warns if the file is locked

Here’s an example of the two file outputs:

Tab-separated values

id	word	words
1	hello	"hello there"
2	goodbye	"goodbye then"
3	a	"a, b, c"

Comma-separated values

id,word,words
1,hello,hello there
2,goodbye,goodby then
3,a,a, b, c

Download ExportDelimitedText

I learnt how to set up Photoshop today so that the screen displays images at the exact same size they will print out, which is great for previewing how your work will look without endless printing and reprinting.

Here’s what you do:

1. Note the size of your screen height in pixels (mine is 1024)
2. Measure the physical height of the pixel-area of your screen using a ruler (mine measured 27.0 cm exactly)
3. Divide the number of pixels by the number of centimetres (1024 / 27 = 37.925)
4. Enter this number in the Screen Resolution box under Preferences > Units & Rulers:

Photoshop will now display your images at the correct size when you choose View > Print Size.

However, it’s a bit of pain to have to go to the menu option each time, but an easy solution is to simply map View > Print Size to the CTRL + ` (top left key):

Now, you can easily swap between 100% and Print Size by alternating between CTRL+1 and CTRL+`