Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2021, 09:27 AM
Planet12345 Planet12345 is offline Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Windows 10 Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Office 2016
Novice
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet
 
Join Date: Nov 2021
Posts: 2
Planet12345 is on a distinguished road
Question 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.
Reply With Quote
  #2  
Old 11-08-2021, 09:55 AM
Charles Kenyon Charles Kenyon is offline Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Windows 10 Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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
Reply With Quote
  #3  
Old 11-08-2021, 12:14 PM
Planet12345 Planet12345 is offline Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Windows 10 Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Office 2016
Novice
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet
 
Join Date: Nov 2021
Posts: 2
Planet12345 is on a distinguished road
Smile 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!
Reply With Quote
  #4  
Old 11-08-2021, 03:48 PM
Charles Kenyon Charles Kenyon is offline Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Windows 10 Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You are welcome. Please follow through on the cross-post etiquette.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet Mail Merge Directory - Page Break Layout Wang Mail Merge 4 08-06-2020 06:16 PM
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet 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
Word Mail Merge Directory Force Page Break For Each Letter In The Alphabet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft