Office Solutions

How to Export the Results of a Query to Multiple Files with Access VBA

Exporting information from Microsoft Access is incredibly easy – assuming you only want to produce a single export file. But what do you do when you need to split a query (or table) into multiple export files? For example, if you need to export a list of customer transactions each month – each customer having their own export file? That’s where this article can help you. Producing an export of 2, 10, or a hundred different exports will be as simple as running a little VBA code snippet and...

Read more »

6 Key Concepts Related to Exchange Forensics Analysis

In this article we look at key concepts related to Ms Exchange Forensics Analysis and look how the same is performed on in-house mail servers and related infrastructure. With the increasing importance of emails as the primary medium of official communication, the threats to email security have also increased. While all companies take steps to ensure the safety of all email accounts and mailboxes, but somehow some of them still fall short on safety. This is probably because the techniques...

Read more »

How to Get the Full Folder Paths of the Search Results with Outlook VBA

When facing myriad search results, you may hope to determine their located folder paths. Outlook has no such a native support for it. But you still can make use of VBA codes to achieve it. This article will expose the elaborate steps to you. In my previous article – “4 Ways to Identify the Located Folder of the Search Results”, I have introduced 4 means to get the located folder of the search results. But all of them can just provide the located folder name. So there will be a trouble...

Read more »