Previously in the article Word Merge Record # Rule ( Mail Merge) I’ve explained about the Merge Record # Rule. The Merge Sequence # Rule inserts the current record number based on the records selected to be printed: So basically if we choose to print all the records then.

Code: Sub Merge_To_Individual_Files() 'Merges one record at a time to the folder containing the mailmerge main document. Code: Sub RunMerge() 'Note: this code requires a reference to the Word object model to be set, via Tools References in the VBE. Code: Sub SplitMergedDocument() ' Sourced from: Application.ScreenUpdating = False Dim i As Long, j As Long, k As Long, StrTxt As String Dim Rng As Range, Doc As Document, HdFt As HeaderFooter Const StrNoChr As String = ''*./:? ' j = InputBox('How many Section breaks are there per record?'

Mac OS: High Sierra Version 10.13.3 Office 365 - Microsoft Office 2016: Version 16.12 - Microsoft Excel 2016: Version 16.12 I have been using mail merge heavily for the last 4 years in Word 2011 and Excel 2011 for Mac. It worked like a charm. Then I had to upgrade to Word 2016 and Excel 2016 because support has ceased for Word and Excel 2011. I have started to create new document templates in Word 2016. I created a new 'Existing List' in Excel 2016.

When I go to merge the excel file into my Word 2016 template I get the following: 'This file needs to be opened by the Excel Workbook text converter, which may pose a security risk if the file you are opening is a malicious file. Choose Yes to open this file only if you are sure it is from a trusted source.' After clicking 'Yes' it takes up to a minute for the merge fields to be allowed.

Contacts in outlook 2007. The data merge fields are only recognized 25-50% of the time. The other 50-75% of the time, an error appears that shows the following: 'The converter necessary to open this file cannot be found.' I have requested assistance with this problem through the online chat the past two days. I have uninstalled (completely) and reinstalled. I have made sure that each of the documents (template and data list) were created in Word 2016 and Excel 2016 (so nothing had to be converted. I have made sure I have all of the newest updates. I am at a loss for what I need to do to make sure that mail merge works for me.