metricsgugl.blogg.se - Mycase and word doc merge

#MYCASE AND WORD DOC MERGE PDF#
#MYCASE AND WORD DOC MERGE CODE#

'' the test data source had unique FileNameĭocLetters.ExportAsFixedFormat OutputFileName:= _

#MYCASE AND WORD DOC MERGE PDF#

INDIVIDUAL PDF FILE MARCO: (note you must have a “FileName” Column in your Excel data source): ' Save generated document and close it after savingĭocLetters.SaveAs FileName:=savePath & sFNameĭ = wdNextRecord '' the test data source had unique surnames ''There is a problem with the recordcount property returning -1ĭ = wdLastRecord INDIVIDUAL WORD FILE MACRO (note you must have a “FileName” Column in your Excel data source): 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. I’m loading both individual pdf creator and individual word file creator.

#MYCASE AND WORD DOC MERGE CODE#

Raduner macro above, Remou macro code for producing pdf’s 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. 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. In fact this is my first attempt at using a macro let alone modifying the code. For me this was not working because of special formatting and tables inside the tempalte document.įirst let me give credit where credit is due because I know absolutely nothing of writing macros.

There is one thing to do manually, because I couldn’t solve it programmatically: you have to manually set the “Mail Merge Output” setting to “Current Record”! (default is “All”)Īn alternative approach is to split the generated mail merge document based on the section breaks that Word inserts when executing mail merging.

Unfortunately this Macro does not work with Microsoft Office 2010+ on Windows! (Reason is the next point #2).

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. But I wanted to have each form in a seperate word document. 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. Recently I had to create a lot of Microsoft Office Word documents based on the same template, so I decided to use Mail Merge.