Office Solutions

How to Batch Send Multiple Emails via Excel VBA

We examine the code required to send emails in bulk from Excel with data particular to each recipient, plus a general attachment. The workbook used in this exercise can be found here The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". It is further assumed that Outlook is the email program. Data Copy the following text into a...

Read more »

How to Import All Files within a Folder to Your Access Table

Data, data, data – without it a database would be pretty useless. So it’s no surprise that one of the most frequently asked questions when it comes to getting that data into your Access table(s) is – how can I make my life easier when I have to regularly import lots (and lots!) of files? As it’s such a common task, there’s obviously a number of ways to skin that particular cat, but here we’re going to look at just one – in my opinion the easiest – especially if you’re doing...

Read more »

4 Key Points to Consider While Running Antivirus Programs on Exchange Servers

One needs to apply apt thought while choosing a server side antivirus on an Ms Exchange Server and also remain aware of possible issues that may crop up.   The Ms Exchange mailbox databases are full of important and sensitive information which needs all the protection that they can get. Purely from a security view point, running an antivirus program on Ms Exchange Server is a good choice. In fact most experts agree that multilevel security goes a long way in securing your network. ...

Read more »