fixed : set IMAP eMail for Hotmail.com, Live.com and Outlook.com in MacOSX Mail.app

Question :

I’ve always though it was extremely annoying that Microsoft only allowed POP eMail for Hotmail.com for MacOSX, but I kept my Hotmail-account alive for al these years since I actually liked it, even after I switched to Mac…

Recently I heard that Microsoft is finally allowing IMAP access to Hotmail.com eMail, but I can’t figure out how to set it up on my Mac…

Can you please help ?

Answer :

Yes, you’re correct : IMAP eMail has finally come to Hotmail.com, Live.com and Outlook.com eMail.

Setting it up in MacOSX is not as straight forward as one might have hoped however…

The tricky part is that MacOSX will automatically set-up a POP-account if you are setting up a new account in Mail.app using a Hotmail.com, Live.com or Outlook.com eMail-address.

note : instructions for setting-up Hotmail/Live/Outlook-eMail on iPhone/iPad can be found here.

That being said…

If you follow these steps, you will be able to succeed anyway :

( if you are on OSX 10.9 Mavericks, read this first )

1- in OSX Mail.app, go to Preferences, then to Accounts and (if you have one) select your current POP-setup for Hotmail/Live/Outlook from the list, then go to the Account Information tab, and there un-check the “Enable this account” option

2- then use the Plus-button (bottom left) to add a new account

3- in the pulldown-window “Add Account” that appears, fill in your Full Name, type a fake eMail address ( e.g. nobody@blabla.com ) and leave the Password blank, then click on Create

4- in the next window, set the Account Type to “Exchange IMAP” (only if you don’t have that option choose “IMAP”) and use the following info, depending on what eMail-address you have :

for Hotmail.com-eMail, use :

Description : Hotmail IMAP ( or if you perfer your eMail-address, make sure to add “IMAP” or something like that to it, else it will conflict with your previously set-up Hotmail POP )

Incoming Mail Server : imap-mail.outlook.com [ will automatically select Port 993 ]

User Name : username@hotmail.com [ replace “username” by your own username ]

Password : ••••• [ your Hotmail-password ]

Outlook Web Access Server : m.hotmail.com

for Live.com-eMail, use :

Description : Live.com IMAP ( or if you perfer your eMail-address, make sure to add “IMAP” or something like that to it, else it will conflict with your previously set-up Live.com POP )

Incoming Mail Server : imap-mail.outlook.com [ will automatically select Port 993 ]

User Name : username@live.com [ replace “username” by your own username ]

Password : ••••• [ your Live.com-password ]

Outlook Web Access Server : m.live.com

for Outlook.com-eMail, use :

Description : Outlook IMAP ( or if you perfer your eMail-address, make sure to add “IMAP” or something like that to it, else it will conflict with your previously set-up Live.com POP )

Incoming Mail Server : imap-mail.outlook.com [ will automatically select Port 993 ]

User Name : username@outlook.com [ replace “username” by your own username ]

Password : ••••• [ your Outlook.com-password ]

Outlook Web Access Server : m.outlook.com

5- then click “Continue”, and if you get an error-message, just click “Continue” again

6- in the next window put a check-mark in front of “Use SSL”, set Authentication to “Password” and click “Continue” again

7- in the next window, use these settings :

for Hotmail.com-eMail, use :

Description : Hotmail SMTP ( or anything you like )

Outgoing Mail Server : smtp.live.com [ will automatically select Port 25 or Port 465 ]

you can check “Use only this server”, but it’s not obligatory

do check “Use Authentication”

User Name : username@hotmail.com [ replace “username” by your own username ]

Password : ••••• [ your Hotmail.com-password ]

for Live.com-eMail, use :

Description : Live.com SMTP ( or anything you like )

Outgoing Mail Server : smtp.live.com [ will automatically select Port 25 or Port 465 ]

you can check “Use only this server”, but it’s not obligatory

do check “Use Authentication”

User Name : username@live.com [ replace “username” by your own username ]

Password : ••••• [ your Live.com-password ]

for Outlook.com-eMail, use :

Description : Outlook SMTP ( or anything you like )

Outgoing Mail Server : smtp-mail.outlook.com [ will automatically select Port 587 ]

you can check “Use only this server, but it’s not obligatory

do check “Use Authentication”

User Name : username@outlook.com [ replace “username” by your own username ]

Password : ••••• [ your Outlook.com-password ]

8- then click “Continue” and if you get an error message, just click “Continue” again

9- in the next window, put a check-mark at “Use SSL”, select Authentication “Password” ( or “External (TSL client Certificate)” if you happen to have that ), and click “Continue”

10- in the next window, put a check-mark at “Take account online” and click on “Create”

11- then, back in Mail.app’s Prefecences, under Accounts, select your newly created eMail-account and click on the “Account Information”-tab and re-type your correct eMail-address in “Email Address:” (replacing the nobody@blabla.com you had originally entered) and check if all settings are as they need to be according to the above

12- then exit the Mail.app Prefecences (click the red button upper left) and click “Save” when the “Save changes” pulldown window appears

13- now, back in Mail.app itself (if you do not see the normal Mail window, go to File –> New Viewer Window), you will see the new Hotmail/Live/Outlook account has appeared, and it is looking for your old & new eMails on the Hotmail/Live/Outlook-mail servers

…most people will have lots of old eMails to import, so this might take some time (don’t be surprised if this takes 15, 20 or maybe even 30 minutes…)

14- if the import of the old & new eMails from the Hotmail/Live/Outlook-mail servers is complete, they will appear in the Inbox window and you’re done…

Congratulations !

…if you do not see your old & new eMails appearing, but you do see an “Unread eMails”-number next to the name of the Hotmail/Live/Outlook-inbox in the listing on the left, you have run into a bug in Mail.app that was only recently solved in OSX 10.8.5

to manually solve this problem, quit Mail.app, open Disk Utility (from the Applications –> Utilities folder), run “Repair Disk Permissions” on your Hard Drive’s main partition and when that’s finished, re-open Mail.app and all should be solved

Enjoy !

Donate Button (MacManusNL)

fixed : AirDrop from Mac to iPhone/iPad

Question :

I’ve just installed iOS 7 on my iPhone 5, and since I was reading about AirDrop being one of the new features, I immediately thought of using AirDrop to get this picture I just made onto my iPhone…

But when I turn on AirDrop on both my Mac and my iPhone, they can’t seem to see each other…

Is there any way to get this to work ?

Answer :

No – at least : officially not.

So far, AirDrop is only available on Macs with supported AirPort-cards running MacOSX 10.7 “Lion” or newer and on the iPhone 5 and newer running iOS 7…

Furthermore, AirDrop is only supported Mac-to-Mac or iPhone/iPad-to-iPhone/iPad…

Maybe this situation will change with the introduction of OSX 10.9 “Mavericks”, but for now there is no (official) option to use AirDrop from Mac-to-iPhone/iPad and vice-versa…

But…

There is an alternative that works the same basically : AirDisk Pro

(note : seems like Phone Drive and Phone Drive FREE are exactly the same app as AirDisk Pro, but at a lower price, even free…)

With this AirDrop-alternative, file transfer is very quick …and it’s even more compatible than the official AirDrop : the app can be installed on any iPhone or iPad running iOS 4.3 and the WiFi-connection can be made from any Mac or PC using a web browser…

In short, the app works like this :

– install the app on your iPhone/iPad

get AirDisk Pro
get Phone Drive FREE [stores max. 10 files]
get Phone Drive

– make sure your iPhone/iPad and your Mac/PC are on the same WiFi-network

– run the app

– enter the IP-address (or network name) that the app gives you as a URL in your Mac/PC’s web browser

– drag the file you want to transfer onto the webpage

done !

enjoy 😉

Donate Button (MacManusNL)

fixed : copied Excel data only shows zeros instead of original values

Question :

I have this data-range in MS Excel that I want to copy from one page to another, but when I do, in the area that I want to copy to, all cells are filled with zeros…

…the original data has disappeared…

How can I fix this ?

Answer :

Just use the “Paste Special”-option from the Edit-menu, like this :

– in MS Excel, go to the data that you want to copy

– select the range of data you want to copy

– press CMD + C (or choose “Copy” from the Edit-menu)

– then go to the area you want to copy the data to, and select the upper-left cell of the area you want the copied data to appear in

–  then press SHIFT + CMD + V (or choose “Paste Special” from the Edit-menu)

– in the pop-up window that appears, select “Values” (the option third from the top) instead of “All” (which was the first option from the top), and click “OK”

– now the original data will appear

…that’s it !

Enjoy ! 😉

Donate Button (all)

fixed : copy a row into a column (or a column into a row) in MS Excel

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! 😉

Donate Button (all)