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 Excel · Microsoft Word · SharePoint

SharePoint Opening Online Version Instead of Desktop Version

If you are trying to edit documents that you’ve opened in SharePoint but it keeps opening them up using the online version of WORD, Excel, etc., you may be getting a bit frustrated if you prefer using the desktop versions. Here’s how to change the default to open the documents using your desktop version. First,… Continue reading SharePoint Opening Online Version Instead of Desktop Version

Microsoft Access · Microsoft Word

Microsoft Access – Merge Many-To-One Records to Microsoft Word

I’ve got to give all props to Graham Mayor. His add-on was brilliant and did the job! If you need to have more than one record put on a Word document, based on a field’s value, Graham’s add-on is your solution. If you have several items that need billed to one account, for example, you… Continue reading Microsoft Access – Merge Many-To-One Records to Microsoft Word

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