|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet
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. |
#2
|
|||
|
|||
Have you looked at Paul Edstein's tutorial?
Catalogue/Directory Mailmerge Tutorial It is pinned in the Mail Merge Forum. Cross-posted at:https://answers.microsoft.com/en-us/...4-06e6a14965ac For cross-posting etiquette, please read: A Message to Forum Cross-Posters Excelguru Help Site - A message to forum cross posters |
#3
|
|||
|
|||
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet
Thank you! I copied and pasted the string of commands into my mail merge document, made the changes, and it worked perfectly. I truly appreciate the help!
|
#4
|
|||
|
|||
You are welcome. Please follow through on the cross-post etiquette.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Directory - Page Break Layout | Wang | Mail Merge | 4 | 08-06-2020 06:16 PM |
Directory Mail Merge Letter Format Problem | slunkc | Mail Merge | 3 | 03-21-2017 11:16 AM |
mail merge with 2/3 keys? cant get page break | Lisa274 | Mail Merge | 5 | 01-06-2014 05:13 PM |
Detecting Page Breaks in Mail Merge Directory | TimK9VB | Mail Merge | 6 | 11-20-2012 01:52 PM |
Force a page break | Emaleth9999 | Mail Merge | 1 | 02-09-2012 02:36 AM |