Hi everybody Unfortunately I can't solve my merge letter problem and I have tried everything to solve it. For a better explanation I've made some screenshots of the spreadsheet and Word file. See attached In the spreadsheet I have several customers who have different campaigns. Now I want to print in Word per employer the different campaigns on one site. Now I tried to merge the data but I get only 6 pages from the employers which I marked green in the first picture. The other employers (it should be 12 pages) do not appear and I don't know why. Does anybody know why? List photo editing software for mac free download. Based on BenVista's award-winning S-Spline Max technology, it can expand your favorite pictures to any dimensions you choose, up to 300,000 x 300,000 pixels, all without sacrificing a single pixel. ![]() Thanks for your help! Your current approach won't work. Instead you could use Word's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: or: The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. It's usually simpler to work with the field code shortcut keys and enter them manually - on WIndows Word, ctrl-F9 to insert a pair of the special field code braces, alt-F9 to toggle between field code view and results view, F9 to update selected fields and so on. ![]() Depending on what you're trying to achieve, the field coding for this can be complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. For some worked examples, see the attachments to the posts at: Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document, with a workbook that contains a single instance of each of your employer names and IDs on one worksheet - which is used for the mailmerge data source - and your existing worksheet which is referenced by a DATABASE field. Or you could keep your existing workbook setup and use both a DATABASE field and a macro to drive the process. An example of this approach can be found at: The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from: Graham Mayor at or Doug Robbins at.
0 Comments
Leave a Reply. |