Mail Merge is in my opinion one of the best features of Microsoft Word. It is a hugely popular and powerful tool.
This post will walk through generating a mail merge to produce labels from data stored in an Excel spreadsheet. Continue reading
Mail Merge can handle conditional rules such as If… Then… Else… to display different text depending on the information in the data source record. Normally these rules are quite simple tasks such as; if the member joined within the last month, or if they have a family membership.
Sometimes though you may need to use multiple conditions. For example, you may want to check if a member of a club had a Gold, Silver or Bronze membership. The new price of their membership depends on what membership they have.
Begin by inserting a basic If… Then… Else… rule. This gives you a head start with typing the rules by inserting the structure of the condition. It’s easier to expand on this rule, than write one from nothing.