merge · Microsoft Access · Microsoft Word

WORD MERGE MANY LETTERS TO ONE IN WORD FROM MICROSOFT ACCESS

Say you have several letters you want to do in WORD and your list of contacts is in Access. Here are the instructions to create one document with all the letters but you input numbers into Access to specify which letter will be used. Create new field in Access where you will put numbers in… Continue reading WORD MERGE MANY LETTERS TO ONE IN WORD FROM MICROSOFT ACCESS

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