Mail Merge Directory Conditional Page Break

P

Planet12345

Joined
Nov 8, 2021
Messages
1
Reaction score
0
I am using am Excel spreadsheet as my source file for my alphabetized customer price list. When I merge to a Word directory, I would like to have a page break automatically inserted at each letter of the alphabet. In source file, I added a first column that contains only the first letter of each customer names, hoping I can use that field (named "ALPHA") to use as the conditional field. If anyone can help me with the syntax, I would greatly appreciate it. FIrst is my Excel sheet (simplified), then is the Word file with the actual merge codes.
1636383274405.png

1636383463051.png
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge file containing a Word Table 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Embedded Excel into Word with Tables 0
Insert name and adress from a list in a word document 1
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Page numbering with Merged Document and IF statements 1
Mail Merge - displaying a conditional number of decimals 5
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top