![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Wang | Mail Merge | 4 | 08-06-2020 06:16 PM |
![]() |
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 |
![]() |
TimK9VB | Mail Merge | 6 | 11-20-2012 01:52 PM |
Force a page break | Emaleth9999 | Mail Merge | 1 | 02-09-2012 02:36 AM |