mail merge not working with office 2013

Can you send me a copy of the data source.  You can remove the records if you want, but leave the first row with the field names.  I will then take a look and see what is causing the problem.

Hi Doug, 

I re-installed the tool and it seems to be working fine now. Thanks!

I created an excel sheet with the contacts and used a letter type, as described. Whenever I click on the many-to-one tool though, I get a "mismatch error 13". I guess I've a mistake somewhere in my excel.. The letter template I had used had address, title, recipient name, etc.. I deleted all placeholders from that template and kept what is relevant for me (i.e. recipient name, as I just want to send a personalized email). When I hover over "Recipient Name" with the mouse, it shows "Name", which is why I tried naming my excel column both as "Name" and Recipient Name", but didn't help solving the mismatch error.

I just don't get why the microsoft mail merge tool isn't functioning properly. I tried using text/HTML, didn't seem to help. And I am able to send attachments directly from word.

Thank you so much for your help!

Do NOT use the MergeTools – 20140218.dotm as a template.

If you go to the Developer tab of the ribbon and click on the Document Template item in the Templates section, do you see the MergeTools – 20140218.dotm item in the list of "Checked items are currently loaded." on the Templates tab of the Templates and Add-ins dialog? 

If not, you have NOT saved the file in the correct folder.

If it is in the list, but does not have a tick in the box beside it, click on that box to load it.

Thanks a lot Doug. I did manage to save the document in the right location, but can't see the merge-tool ribbon in any new word document which I open. I tried using the downloaded document itself (sort of like a template) because it does contain the ribbon, but ended up with the following message "attach the data source and re-run this macro". Thanks a lot for your help.

The file that you need to download and SAVE IN the Word Startup folder is the one that is selected in the following screen shot:

The MergeTools – 20140218.dotm file needs to be saved in the Word Startup folder.  In Windows XP the default location for that folder is

C:\Documents and Settings[User Name]\Application Data\Microsoft\Word\STARTUP

In Windows Vista and Windows 7, 8 or 8.1 it is

C:\Users[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

If you do not see the AppData folder: -

In Windows 7, - In Windows Explorer, click on the Organize drop down and then on Folder and search options and in the Folder Options dialog, go to the View tab and select the item "Show hidden files, folders, and drives".  While there, it is a good idea to uncheck the box of "Hide extensions for known file types".

In Windows 8 and 8.1, in the File Explorer, click on Options on the View tab of the ribbon and then on the View tab in the dialog that appears and select the item "Show hidden files, folders, and drives".  While there, it is a good idea to uncheck the box of "Hide extensions for known file types".

When that has been done and Word is started\re-started, the tab shown below will be added to the Ribbon:

The requirements for using the system are:

1. The mail merge main document must be of the Letter type, though that does not mean that the output cannot be sent as an e-mail message.
2. The data source must be in the form of an Excel worksheet and that worksheet must be the first sheet in the Excel workbook. If the data is on some other sheet, you can easily move that sheet so that it is the first sheet in the workbook by clicking on the sheet tab and dragging it to the left.
3. The field names must be in the first row of the worksheet and there must be a field name in all of the cells in that row that are within the range of columns that contain the data.
4. The field names must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9).
5. The data must start in the second row of the worksheet and there should be no empty rows within the range of data that is to be processed.

You may also want to download:

1. the Merging with Attachments document that is also on that page which explains how the system is used.  It is not actually necessary to have separate attachments as the facility can be used to send just the documents created by the merge itself as attachments, either as the body of the message itself or in the form of Word files or .pdf files.
2. the Mail Merging with Charts document that is also on that page.  That document explains how you must set up the Excel Data Source and the Mail Merge Main document to be able to execute a merge with a Chart that is unique to each record in the data source.
3. the Using the Many to One Facility document that describes how to use that facility.