The default location is My Data Sources in your personal Documents folder.The saved file is in Microsoft Access database format, so you can also open and edit it with Microsoft Access.A Microsoft Office Master Instructor, she has educated more than a quarter of a million corporate students with her online courses, and hundreds more as an adjunct instructor at Purdue University.
Create A Mail Merge Document In Word 2016 Code In Word2010February 2014 at 21:59 Ive just used your original code in Word2010, and many thanks for putting it together. Unfortunately when you generate a document from a defined Mail Merge template in Word, you end up having all the pages inside one huge document. To achieve this non-standard behavior, I wrote a little helper: execute the following VBA Macro on your Office Word Mail Merge template to have Word generate save every record into a single file. Attention Unfortunately this Macro does not work with Microsoft Office 2010 on Windows (Reason is the next point 2) There is one thing to do manually, because I couldnt solve it programmatically: you have to manually set the Mail Merge Output setting to Current Record (default is All) Heres the VBA code for the Macro: Alternative approach An alternative approach is to split the generated mail merge document based on the section breaks that Word inserts when executing mail merging. For me this was not working because of special formatting and tables inside the tempalte document. Oliver 18. Create A Mail Merge Document In Word 2016 Free WiFi AccessJanuary 2013 Development, Microsoft, Microsoft Word, Software, Solutions Post navigation Previous post OS X: Remove delay of the Dock Next post How-to instantly renew free WiFi Access at Hamburg Airport 24 thoughts on Microsoft Word: Mail Merge into single documents Pingback: Oliver Raduner (oliverattweetin) Oliver Raduner says: 4. September 2013 at 20:22 Nino: you missed one IMPORTANT thing See in my article what I wrote under Attention: There is one thing to do manually, because I couldnt solve it programmatically: you have to manually set the Mail Merge Output setting to Current Record (default is All) If you dont change this setting manually, it will copy all the mail merge letters into each of the documents just as you described your problem Hope it helps Reply tarek says: 7. October 2013 at 09:26 Kindly clarify in step by step how to (manually set the Mail Merge Output setting to Current Record) Reply Oliver Raduner says: 7. October 2013 at 13:26 tarek: in Office for Microsoft Windows, you can find the settings as shown in this screenshot: 1) In the Mail Merge Ribbon, click on Finish Merge 2) Click on Edit individual Documents 3) Choose the Current Record radiobutton and confirm with OK Reply tarek says: 7. Yet I have done what youve just suggested and after that the code, when runs, is saving seperate files that are all equally the same (copies of the same record). October 2013 at 11:31 Hi again, please I just want to know the step by step how to insert the code and how to run the code, because if we have to do it manually then what is the use of the code Reply Oliver Raduner says: 8. October 2013 at 23:42 Ok I tested it again with Microsoft Word 2012 on WINDOWS and I have to admit unfortunately, that the Macro-Code does NOT work with that Version of MS Word I would need to investigate further but the problem is definitely, that the lastRecord is not being calculated correctly, according to the Datasource (list of addresses, or similiar) used for Mail Merge. December 2013 at 13:06 First let me give credit where credit is due because I know absolutely nothing of writing macros. In fact this is my first attempt at using a macro let alone modifying the code. Armed only with 24 year old knowledge of Basic (yes the original, not Visual Basic) and Fortran (no not the punch card Fortan but really close) I took Mr. Raduner macro above, Remou macro code for producing pdfs at the following link, and a few others and combined different aspects and PRESTO I clearly got very lucky but it works in MS Word 2010. Im loading both individual pdf creator and individual word file creator. I hope Mr. Raduner will work his magic, clean this up and make it more user friendly for everyone else as he clearly knows way more than I do. INDIVIDUAL WORD FILE MACRO (note you must have a FileName Column in your Excel data source): code langvb. There is a problem with the recordcount property returning -1. December 2013 at 14:38 Awesome Thank you, Raymond, for sharing the code And I am happy that you got it working. When I run the VBA code for the Macro (MailMergeSaveEachRecordToFile()), Word generate single files with document name as I choose. But inside each of them are all the pages and not just one form. If I set the Mail Merge Output setting to Current Record, Ive got just one new document with one form in it. December 2013 at 20:56 Luka, Have you tried generating the Mail Merge without the Macro and verify the output It might be, that you missing the Next record field in the bottom of your template.
0 Comments
Leave a Reply. |