Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-20-2021, 02:31 AM
YellowPancakes YellowPancakes is offline Merge records by category + Send each category to a new page Windows 10 Merge records by category + Send each category to a new page Office 2016
Novice
Merge records by category + Send each category to a new page
 
Join Date: May 2021
Posts: 2
YellowPancakes is on a distinguished road
Unhappy Merge records by category + Send each category to a new page

I am trying to do "merge records by category" and "send each category to a new page" from macropod's Catalogue Mailmerge Tutorial using the field shown in attachment: mailmerge_test.docx



However, when I run that field (shown in attachment: mailmerge_merged.docx), it's creating a page per row and it's having random page breaks as shown in page 3.

Please helpp
Attached Files
File Type: xlsx datafile.xlsx (8.9 KB, 3 views)
File Type: docx mailmerge test.docx (16.1 KB, 5 views)
File Type: docx mailmerge_merged.docx (14.5 KB, 4 views)
Reply With Quote
  #2  
Old 05-20-2021, 03:36 AM
gmayor's Avatar
gmayor gmayor is offline Merge records by category + Send each category to a new page Windows 10 Merge records by category + Send each category to a new page Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,570
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

This is a many to one mail merge -see Merge Many To One
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-20-2021, 06:00 AM
macropod's Avatar
macropod macropod is offline Merge records by category + Send each category to a new page Windows 10 Merge records by category + Send each category to a new page Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by YellowPancakes View Post
I am trying to do "merge records by category" and "send each category to a new page" from macropod's Catalogue Mailmerge Tutorial using the field shown in attachment: mailmerge_test.docx

However, when I run that field (shown in attachment: mailmerge_merged.docx), it's creating a page per row and it's having random page breaks as shown in page 3.
Doubtless that's because you've configured the mailmerge as a Letter merge instead of as a Directory/Caltalogue merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-20-2021, 06:40 AM
YellowPancakes YellowPancakes is offline Merge records by category + Send each category to a new page Windows 10 Merge records by category + Send each category to a new page Office 2010
Novice
Merge records by category + Send each category to a new page
 
Join Date: May 2021
Posts: 2
YellowPancakes is on a distinguished road
Default

Ohh! My bad hahaha I managed to get it now. Thanks!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group Category Mail Merge fairchance Mail Merge 18 11-29-2015 03:52 AM
Merge records by category + Send each category to a new page label merge category based... versjan Mail Merge 4 07-15-2015 01:06 AM
Merge records by category + Send each category to a new page Mail Merge - Send Each Category to a New Page cjw Mail Merge 2 10-23-2014 01:25 PM
Macro to export email to text file on send depending on category Joe Patrick Outlook 0 10-19-2012 06:20 PM
How to create a Main category mirrored in Sub category data entry type of solution? Geza59 Excel 0 10-19-2012 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 AM.


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