How to Deal with “Can’t Append All Records in the Append Query” Error in MS Access

In this article we examine scenarios which generate errors relating to failure to append records in MS Access In MS Access, an append query is used when a user updates some records to an existing table, usually from other sources.  Append query basically selects new records from other sources of data and copies them to the table in database. It is helpful in appending multiple records at once and it also allows the user to refine the selection with certain criteria. Users can review the...

Read more »

How to Quickly Get a List of All Outlook PST Files on Your Local Drive via VBA

If you hope to get a list of all the Outlook PST files stored on a local drive of your PC, you can utilize the piece of VBA code shown in this article. It can allow you to get it in quick time. Maybe you have created and stored many Outlook PST files on a partition of your computer. Yet, with time going on, you may forget the concrete location of these PST files. In this case, you may want to quickly find out them and achieve a list of their information, including name, size and path. In...

Read more »

2 Methods to Auto Insert Signature to Meeting Invitations in Outlook

You may have noted that Outlook can only be set to auto insert signature to emails. It can’t auto insert signature to meeting invitations. Hence, this article will look at this issue and share 2 means to achieve it. You can’t configure Outlook to auto insert a signature to meeting invitation. This “Auto-signature” feature is available for email only. Therefore, if you want to auto insert signature to outgoing meeting requests, you need seek other means. Here, we will introduce you 2...

Read more »