Tag Archives: Word

Word Mail Merge Match Fields

I’ve previously explained about the Address Block and Greeting Line features of Mail Merge in the articles below: Word Mailings Address Block (Mail Merge) Word Mailings Greeting Line (Mail Merge) Basically what they do is, they generate a block of text containing the recipient’s address and

No Thumbnail

Word VBA OverFlow Error When Multiplying/Adding Integers

It might have occurred to you when working with integers in VBA for Word that you get the following error: This error generally occurs when you are doing arithmetic operations on integer values that result in: Values larger than 32767 Values smaller than -32768 This is because integers only

No Thumbnail

Word VBA, Assign Shortcut Key to Macro

This article explains how you can assign a shortcut key or key combination to a macro. – Step 1: Press the “File” button on the top left of the word application, then click on options:   Note: In word 2007, there will be an “Office

Word IF Then Else Rule (Mail Merge) Insert Fields

Previously in the article Word IF Then Else Rule (Mail Merge) I’ve explained how you can use the If Then Rule in Mail Merge. In that article the If Then Else Field would insert a text string based on the result of the comparison. In this article I will

No Thumbnail

Word VBA, Delete Empty Rows From Tables

One of the things a lot of word users encounter while working in word, are empty rows in tables. In this article I will provide a code that will delete all empty rows from all tables in the document. – Delete Empty Rows From Single Table: In

Word Ask Rule (Mail Merge)

In this article I will explain the Ask Rule used in Mail Merge. Note: It is assumed that readers are familiar with Mail Merge before reading this article. – What is it? In Mail Merge we basically have a list of recipients, with specific data for each

No Thumbnail

VBA, Write Excel Values to Word Document

In this article I will explain how you can write data from an excel workbook to a word document. The first step in doing this is to determine where the code is going to be written. There are 3 options: In the excel workbook In the

Word Mailings Greeting Line (Mail Merge)

In this article I will explain the Greeting Line in word. – What is it? Lets say you want to send the same letter to a 100 different recipients. Consider the following letter: Everything in this letter is the same for all recipients except for the greeting line

privacy policy