Microsoft word mail merge separate documents

Thanks for the help. 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.

For the Chart Merge utility, see the Mail Merging with Charts document that is included in the Merge Tools Add-in Zip file for additional requirements for the data source for use with that utility. The number of characters in the field names, including spaces, must not be more than Was this reply helpful? Yes No. The Long Version. Adding the Macro. Right click and select "Customise the Ribbon". Make sure the checkbox next to Developer in the right-hand column is checked. Click the Visual Basic button.

If needed, click on the View menu and select "Project Explorer". Right click on "Normal". Select "Insert" and then "Module" in the contextual menu. A new module i. Copy the macro from this article and paste it into Module1 the VBA editor. Preparing the Data. Prepare your as you would for any other mail merge, i. For folders, copy the address from the address bar in Windows Explorer.

You can use formulas to create any field, here the file name is created from "End of year letter to " and the person's name. Preparing the Mail Merge Template. Prepare your mail merge template in Word as for a normal mail merge - there is no need to add the extra fields anywhere.

Sit back and let the magic happen. In the Developer tab click the "Macros" button. Mail merge in progress Mail merge to PDF complete! Share This Post. Share on facebook. To use a different order, select and insert each file individually in the desired order.

For more information, see the Forum. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. The only answer to accomplishing this task is to create a macro that will, based on the merged document the page one mentioned above take each section and save it to its own document file.

If you look in Microsoft's Knowledge Base, you will find that there is an old article that deals with this very issue:. The macro presented in the article, even though it was written for an older version of Word, will work just fine in later versions. It allows you to separate a merged document into individual files, based on the section breaks:.

It is important to realize, however, that this macro will only work if the only place that section breaks occur is between merged documents. If your original document includes section breaks, then the macro will not provide satisfactory results.

For additional information on using the macro, refer to the Knowledge Base article at the link provided above. Note: If you would like to know how to use the macros described on this page or on any other page on the WordTips sites , I've prepared a special page that includes helpful information.

Click here to open that special page in a new browser tab. WordTips is your source for cost-effective Microsoft Word training. Microsoft Word is the most popular word processing software in the world. This tip applies to Microsoft Word 97, , , and You can find a version of this tip for the ribbon interface of Word Word and later here: Merging to Individual Files.

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates , a computer and publishing services company. Learn more about Allen When pasting information copied from a PDF file, you can end up with a paragraph for each line of the original document. You can use the Windows Clipboard to move information around in Word. To make the most of the Clipboard, it is helpful to Word provides quite a bit of latitude when it comes to formatting your underlines.

This tip looks at how to best change This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. As you develop a document, Word keeps track of certain statistics about the document itself. Here is how you can review You may be surprised sometime to save a document and find out that Word actually saves what appear to be two copies of Open a file that isn't a Word document and Word will still try to convert it to a Word document.

If you want Word to let Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. Hi, I tried sending multiple documents via an email and word has merged them.

Trouble is that anything I do in word now gets merged into that file and I've no clue what's happened or how to undo it. Any help from anyone is greatly appreciated Thanks. Hi I have the same question as many peoples here I would like to know how to save a document with a name. Please help : The goal was to used a spreedsheet in excel and fill out individual letter, I achieved that but I have an issue with the naming of each individual document to generic if I used the template from this article.

Also wondering if someone know why using allen macro the spacing goes from 1 to 1.