Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2021, 11:01 AM
BNDCK BNDCK is offline Grouping {MERGEFIELD} into 2 or 3 Columns Windows 10 Grouping {MERGEFIELD} into 2 or 3 Columns Office 2010
Novice
Grouping {MERGEFIELD} into 2 or 3 Columns
 
Join Date: Jul 2021
Posts: 2
BNDCK is on a distinguished road
Default Grouping {MERGEFIELD} into 2 or 3 Columns

Hello There,
my part of excel sheet like this



MINNO CPNO
1 21/1025
1 21/2058
1 21/1065
1 21/1069
2 21/1025
2 21/1029
2 21/1035

an so on, roughly 1000 rows,

My Merge Document is like this



{if {MERGESEQ} = "1""
{ MERGEFIELD Customer_Name}
.................................................. ...............
-------body of the letter---------




-----Page Break---------------

.................................................. ...............
-------body of the letter---------


Merged letter something like this


Allan Craft

-----letter body----


1627925908480.png

21/1025 21/2058 21/1065


next page for next customer and continue. My code produce first page exactly what I wanted. rest of the pages does not come as group. what's wrong in my code. please can someone point me out.

Note : If I write to display as one after the other letters are prepared as I wanted.

like this

21/1025
21/2058
21/1065
....... and so on.

Thanks
Reply With Quote
  #2  
Old 08-03-2021, 01:07 AM
gmayor's Avatar
gmayor gmayor is offline Grouping {MERGEFIELD} into 2 or 3 Columns Windows 10 Grouping {MERGEFIELD} into 2 or 3 Columns Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping {MERGEFIELD} into 2 or 3 Columns IncludePicture with Mergefield paluccie Mail Merge 3 03-13-2021 06:34 AM
Grouping {MERGEFIELD} into 2 or 3 Columns Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Grouping {MERGEFIELD} into 2 or 3 Columns Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
SUM a single mergefield kawirider88 Mail Merge 1 09-29-2013 06:37 PM
Grouping {MERGEFIELD} into 2 or 3 Columns Substituting a value using MERGEFIELD CharlieVW Mail Merge 3 05-07-2012 12:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 AM.


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