I need each record to merge into the template and save as "> - >.docx", for a total of 534 word docs created.ĭoes anyone know of a solution that will work for me? Many thanks in advance.
(Or you can go to the Mailings tab > Start Mail Merge group and click Start Mail Merge > Labels. In the first step of the wizard, you select Labels and click Next: Starting document near the bottom. I already tried the solution where the first line is set to heading1 style with a page break at the end, and I kept getting "The selection does not consist of heading levels" error message no matter what I tried. The Mail Merge pane will open in the right part of the screen. I've spent several days making sure I followed instructions for each one precisely, and I guess I need help specific to my task and programs (the other solutions I tried were designed in earlier versions of Word I don't know if that makes a difference or not).Īttached are the source data spreadsheet and the Word template.
I have tried to adapt and use 4 different vba scripts found in similar threads and on other sites, with none of them working so far. Using this format means that all future additions to our Excel file will quickly reflect in the Mail Merge. I used the Name manager in Excel and named all of the columns. I did it last year but dont remember how.
I have a table of information.each row is a client.and I want to create a letter per row (or client) using the data in Excel. I have an Excel 2013 source file, and a Word 2013 template that I am trying to merge, with each record creating a new Word document, using a combination of two of the fields in each record. The Mail Merge document will be saved and connected to the Excel Source file in an as-is format. This is probably very simple and basic but, I want to do a mail merge within Excel and not use Word.