Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2018, 10:16 AM
sprinke sprinke is offline Grouping fields in header? Windows XP Grouping fields in header? Office 2016
Novice
Grouping fields in header?
 
Join Date: Sep 2018
Posts: 3
sprinke is on a distinguished road
Default Grouping fields in header?


I have been studying macropod's "Catalogue Mailmerge Tutorial" and had a question. I would like the grouping field(s) to be repeated on each new page. Is it possible to put the code in the header of the word document? Or is there some other way to repeat on each page?
Reply With Quote
  #2  
Old 09-27-2018, 05:25 PM
macropod's Avatar
macropod macropod is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Directory merges don't support the insertion of mergefields into the page header. There may be other ways of achieving the desired outcome but, without seeing your mailmerge main document, it's impossible to advise. Canyour mailmerge main document to a post with an indication of precisely what you want repeated? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-27-2018, 05:50 PM
macropod's Avatar
macropod macropod is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: https://answers.microsoft.com/en-us/...9-2b7f45ec5d62
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 09-28-2018, 08:21 AM
sprinke sprinke is offline Grouping fields in header? Windows XP Grouping fields in header? Office 2016
Novice
Grouping fields in header?
 
Join Date: Sep 2018
Posts: 3
sprinke is on a distinguished road
Default

Sorry about the cross post; I won't do it again. I tried to close the other thread on the answers.microsoft.com forum.

In any case, I don't really have any sort of working document to post. What I'm really looking for, is something like a yearbook. At the top, there will be a header, that will be repeated on multiple pages if necessary. In the main body of the document, there will be a grid of photos, with names and some other fields underneath each photo.

I'm not even sure where to start with something like this. The need for grouping would indicate that this must be a Directory-style merge, but I also found this in the tips:

Catalog/Directory Mailmerge to Label Stationery
To use a catalog mailmerge with label stationery, all you need to do is to set up the page layout in the mailmerge main document so that you've got the same column layout and margins as the labels, then put the mergefields inside a single-cell table of the correct dimensions for a single label.

I was trying to play with this, but I must not be understanding it correctly, because I'm getting one cell per page.

I attached an image sample of the type of output I'm looking for.
Attached Images
File Type: png Capture.PNG (190.5 KB, 20 views)
Reply With Quote
  #5  
Old 09-28-2018, 02:09 PM
macropod's Avatar
macropod macropod is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The kind of merge you're trying to do does not need a directory merge. Moreover, it's not apparent from your image what fields, if any, are to be repeated on every page; your image suggests nothing more complicated than a label merge with a page header.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 09-28-2018, 02:51 PM
sprinke sprinke is offline Grouping fields in header? Windows XP Grouping fields in header? Office 2016
Novice
Grouping fields in header?
 
Join Date: Sep 2018
Posts: 3
sprinke is on a distinguished road
Default

I would love it if that were so simple. But I'll see if I can explain in a simplified way.

The data format would be something like

Class A ....... Student 1
Class A ....... Student 2
etc., etc. until
Class A ....... Student 100 (so, obviously more students in Class A than will fit on one page)

Class B ....... Student 1
Class B ....... Student 2
etc., etc.
Class B ....... Student 50

Class C ....... Student 1
Class C ....... Student 2

and so on.

In the black header, I have information about Class A. The same information must be repeated at the top of every page that includes students in Class A (100 students / 20 students per page = 5 pages). Then there will be a page break, and Class B will start with a header containing information about Class B. And so on.

Sorry, it was not possible to convey that in a single image.

If this can be done without grouping, that would be fantastic.
Reply With Quote
  #7  
Old 09-28-2018, 03:09 PM
macropod's Avatar
macropod macropod is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The simplest approach would be to perform a series of label merges, one for each class, then combine the documents post-merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 10-09-2018, 03:05 AM
aysherryan aysherryan is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 64bit
Novice
 
Join Date: Aug 2018
Location: Singapore
Posts: 5
aysherryan is on a distinguished road
Default

Index consolidates don't bolster the inclusion of mergefields into the page header. There might be different methods for accomplishing the coveted result yet, without seeing your mailmerge principle archive, it's difficult to prompt. Canyour mailmerge principle archive to a post with a sign of correctly what you need rehashed? You do this by means of the paperclip image on the 'Go Advanced' tab at the base of this screen.
Reply With Quote
  #9  
Old 10-09-2018, 03:41 AM
macropod's Avatar
macropod macropod is offline Grouping fields in header? Windows 7 64bit Grouping fields in header? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by aysherryan View Post
Index consolidates don't bolster the inclusion of mergefields into the page header.
Whatever you're on about, it doesn't seem to have anything to do with the subject matter of this thread; no-one else has even mentioned an Index - which has nothing to do with the OP's mailmerge requirements.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
grouping, grouping with headings

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping fields in header? Header fields not showing text hockeytown Word 2 12-16-2014 06:20 AM
Grouping fields in header? How to update fields in all header definitions ChrisBrewster Word VBA 2 02-10-2014 10:33 AM
Grouping fields in header? Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
Grouping alamorchgirl PowerPoint 0 07-08-2011 02:14 AM
Stumped on Grouping with Custom Fields... ViperMan Project 1 06-22-2011 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 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