Microsoft Word

Suppressing Blank Lines in Address

Microsoft Word – Suppressing Blank Address Lines   On your Word document, put your cursor where you’re inserting your first field. Then go to the MAILINGS tab and click “Insert Field”. To Toggle back and forth to see this formula, highlight all of the section you want to see (it’s ok if you highlight more)… Continue reading Suppressing Blank Lines in Address

Microsoft Access · Microsoft Excel · Microsoft Word

Mail Merge Many-To-One Add-In

This is one of my favorite Word add-in I came across trying to solve a problem I was having. I had an Access database where I wanted to create invoices. I’ll make up an example because mine’s a little harder to explain. Say you have a construction job and everything you purchase you apply to… Continue reading Mail Merge Many-To-One Add-In

Microsoft Access

Microsoft Access Joining Names with Expressions

In this post I will show you how to join customer names (customer plus spouse) and customer salutations. This is very useful when doing Microsoft Word merges into form letters. Open up the Query that you want to create a field for joining customer names and salutations. You will need the customers first name, last name, salutation,… Continue reading Microsoft Access Joining Names with Expressions