Tuesday, 23 June 2015

Receive Yahoo Emails in Outlook 2013 using IMAP

  1. File > Add Account
  2. Manual setup or additional server types > Next
  3. IMAP > Next
  4. Account Settings:
    • Your Name: name show when sending email
    • Email address: Yahoo Mail address
    • Account Type: IMAP
    • Server information: match the Yahoo Mail IMAP settings
    • User Name: Yahoo ID
    • Password: Yahoo account password
    • Require logon using Secure Password Authentication: OFF
  5. More Settings > Outgoing Server tab
    • My outgoing server (SMTP) requires authentication: ON
    • Use same settings as my incoming mail server: ON
  6. Advanced tab settings:
    • Incoming server (POP3) 
      • imap.mail.yahoo.com
      • port: 993 
      • encrypted connection: SSL
    • Outgoing server (SMTP) 
      • smtp.mail.yahoo.com
      • port: 587 
      • encryption type: TLS
  7. Restart Outlook
  8. Send/Receive All Folders to sync


SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...