Directory Mail Merge Letter Format Problem

[macropod]

Originally Posted by slunkc

I've followed macropod's documentation and countless other tutorials on the web without success.

You'd do better to stick with just one approach that's known to work - whether per my tutorial or one of the various Many-to-One addins.

Originally Posted by slunkc

Attached, I have a template and a data sample. ...

I also want a page break after each letter so I can then split them out and save individually by macro. I don't anticipate having trouble with the macro, but I am having all kinds of trouble simply getting the mail merge template coded correctly. Any help is greatly appreciated

Well, for starters, your mailmerge main document isn't set up anything like what's described in the tutorial. For some worked examples of what your mailmerge main document should look like, see:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
Even so, the final layout you're proposing, with all the data on one line, isn't how the merge process in my tutorial (or, AFAIK, any of the Many-to-One addins) would output the data. My tutorial's coding will output each custody code on a new line.

As for splitting the output, if you change the separator page break that's created by the {QUOTE 12} field in the tutorial to a Section break, you could then use the Split Merged Output to Separate Documents macro in the Mailmerge Tips and Tricks 'Sticky' thread at (https://www.msofficeforums.com/mail-...ps-tricks.html) to generate the individual files. That macro could even be modified to reformat the custody codes so they appear sequentially on the same line (assuming they'll all fit on one line).

An alternative approach would be to use a DATABASE field in your existing mailmerge main document to consolidate the custody codes. An example of that approach can be found at http://answers.microsoft.com/en-us/o...1-1996c14dca5d. The macro for letter production there could even be combined with the Send Mailmerge Output to Individual Files macro in the Mailmerge Tips and Tricks 'Sticky' thread to generate the individual documents without the need for an intermediate file.