Office Solutions

How to Escape Quoted Strings for SQL Statement used in Database via Excel VBA

SQL Server uses pairs of single quotes to identify the start and end of a string. Inserting 'Mrs Brown's Boys' into a database table will fail since the three single quotes imply two strings, one of which is incomplete. An escape character is required for the apostrophe after Brown. This article explores the use of a customised VBA function to resolve this anomaly. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google...

Read more »

2 Methods to Create a Contact Group from a List of Contacts in an Excel File

If you would like to create an Outlook contact group from the list of contacts in an Excel file, you can use the 2 methods introduced in this article. Some users are seeking a way to quickly create an Outlook contact group from an Excel file which contains a list of contacts. Of course, you can create such contact group manually. However, it is a bit troublesome. Hence, apart from the manual means, here we’ll additionally introduce another quick method which uses VBA. Method 1: Create...

Read more »

How to Quickly Remove a Specific Contact from All Contact Groups via Outlook VBA

Sometimes, you may want to delete a specific contact from all the contact groups in your Outlook. In this case, searching and deleting one by one is quite cumbersome. So this article will teach you how to quickly accomplish it using VBA. For some reasons, such as one colleague has resigned from your company, you’ll need to remove him from all the contact groups in your Outlook. Otherwise, next time when you send an email to the contact group, he will be likely to receive the email too. It...

Read more »