Thursday, 4 January 2018

Outlook - Find e-mails by date received or sent

Every January I tidy up my Outlook inbox. I move the e-mails from the previous year into a folder (it makes it easier to archive later). To do this I need to select a range of e-mails by date. In this article I'll explain how use Outlook's advanced find to do this. I'm using Outlook 2013 but other versions should be similar.

Scenario 1
It is January 2018. I would like to find all e-mails received and sent during 2017. I currently have no e-mails in my inbox from years prior to 2017.

  1. With the Outlook inbox (Mail) on the screen press Ctrl-Shift-F and the Advanced Find window will appear.
  2. Click Browse and select the Inbox and Sent Items
  3. Click the Advanced tab
  4. Under 'Define more criteria' click Field | Date/Time Fields | Received
  5. Condition = on or before
  6. Value = 31/12/2017
  7. Click Add to List
  8. Under 'Define more criteria' click Field | Date/Time Fields | Sent
  9. Condition = on or before
  10. Value = 31/12/2017
  11. Click Add to List
  12. Click Find Now

Advanced Find on or before

In the above screen shot you can see the list of e-mails (received and sent) for 2017 are shown. At this point I could select those (use Shift-click or Ctrl-A to select them all) and drag them to a folder in my inbox.

Scenario 2
Perhaps you'd like to be more specific and select between a date range? It's very similar to the above but use the Condition 'between' and enter the Value as <start date> and <end date>. Here's an example:

The above will show all the e-mails from 1st January 2017 to 31st December 2017. It doesn't show those from 1st January 2018.

NOTE: Excel uses the date format you have set on your computer. In my examples I'm using dd/mm/yyyy but for those of you in the US you would use mm/dd/yyyy.

The Advanced Find is very powerful and can save you some time. You can do it manually instead of course, it's easy enough to select e-mails by their date from your inbox directly - but it's rather slow and cumbersome, using the Advanced Find it's much faster and more accurate. I hope this has been helpful, feel free to add comments in below if you have some similar tips to share.

Sunday, 8 October 2017

Use floppy disks to expand your smartphone storage (just for fun!)

We never have enough storage on our smartphones. We are taking too many photos, creating too many videos and we want to carry our entire music collections with us. I have a great solution, floppy disks! Probably you've got an old box of them down in your basement or in your loft. Why not make use of them?

In the above photo you can see it actually works. Here's what you need:
  • A smartphone that supports OTG (On-The-Go)
  • I tested this with an Android phone only, I don't know if the iPhone ca, if you know please write in the comments below.
  • An OTG dongle (in my case it's that green thing in the above photo, you can easily buy these, they are not expensive, just search on Amazon or eBay for OTG and you'll find one)
  • External USB floppy disk drive
  • At least one floppy disk (more than one recommended!)
As each 3.5" floppy disk has just 1.44MB of storage space you will need a lot of floppies! ;-)

Just for fun!
Obviously (I hope!) this isn't practical. It was experimenting and I was happy to discover that it works! I was able to copy files to/from the floppy disk. It was funny listening the drive making that iconic zrhk zhrk noise. I think it's rather fast too, relatively speaking.

Seriously speaking
Instead of floppies disks, use OTG and plug in a USB flash drive. That will give you lots of expandable storage that is usable and practical. If you are interested in learning more you can find many demos on Youtube, just search for OTG.

Another real-world application of OTG is to make backups of photos. The following is an article I wrote about this:

OTG is very useful. It's also fun to dig out some old tech and get it to work with modern day kit. Enjoy technology!

Thursday, 24 August 2017

Check files for malware using VirusTotal

Recently I had a fake DHL e-mail and I was interested in the attached Word doc, I wondered what was in it, whether it really was dangerous or not. But I did not want to put myself in any danger, I definitely did not want to open the doc in Word! How could I investigate this file in safety? I saved the e-mail from Outlook as an MSG file. I scanned it using Emisoft's emergency scanner but it didn't find anything. Next I used VirusTotal and that's what I want to talk about in this article today.

VirusTotal is a website. You can upload a suspect file there. It will use many anti-malware software scanners to check for infection. It displays the results and characteristics of the file. It even shows all the different names the different anti-malware companies use for malware.

Here's an example based upon that fake DHL e-mail I received in Outlook.

Open the Outlook e-mail, click File | Save As


You will end up with an MSG file. The MSG file contains the e-mail message text and the attachment (in my case it was a Word doc file - will VirusTotal be clever enough to find the attachment inside the MSG file?).

Browse to

Click Upload and scan file

Select the MSG file

The results will be displayed...

At the top it shows you how many anti-malware engines it used and how many found something nasty inside the file. In my example above 13 out of 58 found malware in the file.

Click on Details to see more information

The above screen shot shows the Details page with the Basic Properties of the file. You can see that it has identified the Word doc and provides some characteristics. This means that VirusTotal is clever enough to read an MSG and see the embedded attachments it might have inside.

Scroll down and there's more information:

Under the OLE section I found some interesting details. The Code Page is Cyrillic. This e-mail was written in German. Why does it have a Word doc written on a PC set to use Cyrillic? It's not conclusive evidence of anything but it does raise suspicions (if we weren't already very suspicious of course!). The template it is based upon is a dotm, that means there could be macros inside - again this points toward it being a dangerous file as macros can be malware. Of course in the above you can also see that VirusTotal has listed the macros inside the file anyway, for sure this is a dangerous file that I will definitely delete.

VirusTotal is an excellent way to investigate possible virus/malware infected files in safety. The website is free but there are some conditions of use, please read those before using it. One thing they do is use the results from your scan in their database. This is a community approach, where they can build up a picture of threats. The best thing is that it uses so many anti-malware engines to scan for malware. You can see all the different names which could help you analyse the threat at an even deeper level. For IT professionals wishing to understand threats to better protect networks and computers, VirusTotal is an invaluable tool.

For a home user, it's also very helpful. However, I would recommend that you are always extra-cautious when handling any suspect file. Make sure you have anti-malware software installed on your computer, make sure your system updates/patches are up-to-date and the most important of all, make sure you have plenty of backups.