Posts Tagged email
Counting Distinct Domains in Email List
Posted by Chris in Tips & Tutorials on September 4th, 2009
I found this MySQL query that counts the number of emails that have the same domain name in a table. This is handy when you want to check which domain, in your list of emails in a table in the database, is the most popular or even the top group of domains. My first guess for the list I wanted to check was that aol.com, yahoo.com, hotmail.com and gmail.com would be the top four, and guess what… they were. 
I editted the query a little to work on the latest version of MySQL:
SELECT DISTINCT (RIGHT(LCASE(email), LENGTH(email) – INSTR(email, ‘@’))) AS domain, COUNT(email) AS number FROM member
GROUP BY (RIGHT(LCASE(email), LENGTH(email) – INSTR(email, ‘@’))) HAVING (((COUNT(email)) > 1)) ORDER BY number DESC;
Adding an Email Account to Outlook 2007
Posted by Chris in Tips & Tutorials on June 29th, 2009
Things you will need before you will be able to set up your email account in any email client:
- Username (in this case, your full email address)
- Password (********)
- Your domain’s mail server address
I am going to demonstrate setting up an email account in MS Outlook 2007 and the previous versions of Outlook are similar. In this example, I will be using the domain name “sampledomain.com” and an email for Bob.
Right… let us start.
In Outlook’s main menu, select “Tools” and the “Account Settings…”
Outlook Menu
In the window that pops up, select “New…” under the “E-mail” tab.
Email New Button
In the next window that pops up, make sure that “Microsoft Exchange, POP3, IMAP, or HTTP” is selected and then click on the next button. In the next screen, select “Manually configure server settings or additional server types” and click next. In the next window, select “Internet E-mail” and then click next.
Now in the next window, fill in your account details as follows:
Email Account Details
Just make sure that the incoming and outgoing mail servers are mail.[your domain] and that your username is your full email address. Your password is of course… your password.
Clicking next and finish will take you back to the accounts settings window were you will now see your new email account listed. Close this window and test you new email…
