Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2015, 02:15 PM
macropod's Avatar
macropod macropod is offline Mailmerge with grouped data Windows 7 64bit Mailmerge with grouped data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,383
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

Did you read the section titled Using the Sample Data File & Mailmerge Main Document in the tutorial document?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 02-02-2015, 02:22 PM
Keith Henderson Keith Henderson is offline Mailmerge with grouped data Windows 7 32bit Mailmerge with grouped data Office 2010 32bit
Novice
Mailmerge with grouped data
 
Join Date: Feb 2015
Posts: 9
Keith Henderson is on a distinguished road
Default

Absolutely. I guess I didn't get the fact that the code was actually in the tutorial. It was the "Viewing The Fields" section that I didn't grasp.

Been at this for a couple of days now. Just not getting it to do what I was hoping. From all the searching I have done, you appear to be the Guru.
Reply With Quote
  #3  
Old 02-02-2015, 02:27 PM
Keith Henderson Keith Henderson is offline Mailmerge with grouped data Windows 7 32bit Mailmerge with grouped data Office 2010 32bit
Novice
Mailmerge with grouped data
 
Join Date: Feb 2015
Posts: 9
Keith Henderson is on a distinguished road
Default

I played with that simple example that uses the failing student/Teacher name example. Seems like that is the concept I need to follow but after trying numerous times, I could not get it to work. Something seems to be missing with the even paring of field code brackets. Or, I'm just an idiot.
Reply With Quote
  #4  
Old 02-02-2015, 03:08 PM
Keith Henderson Keith Henderson is offline Mailmerge with grouped data Windows 7 32bit Mailmerge with grouped data Office 2010 32bit
Novice
Mailmerge with grouped data
 
Join Date: Feb 2015
Posts: 9
Keith Henderson is on a distinguished road
Default

I can't find the code that keeps printing records on one letter until the Key changes.

I also need a better understanding of how/where template text gets folded in to the coding.
Reply With Quote
  #5  
Old 02-02-2015, 04:20 PM
macropod's Avatar
macropod macropod is offline Mailmerge with grouped data Windows 7 64bit Mailmerge with grouped data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,383
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 Keith Henderson View Post
I can't find the code that keeps printing records on one letter until the Key changes.
Is your mailmerge main document configured for a Directory merge?
Quote:
Originally Posted by Keith Henderson View Post
I also need a better understanding of how/where template text gets folded in to the coding.
The field code provides for text both before and after the repeated records. If you expand the field code for the 'Using One Key' example from page 9 of the tutorial, except for the colouring, you'll see:
Code:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""} {SET LastKey {REF Key}}}{IF{MERGEFIELD State}<> {REF Key} "{IF{MERGESEQ}> 1 "↵

If you require more details about the above sales figures, please contact your {REF LastKey} Sales Manager.↵

Sincerely,↵


Customer Service Manager (National)↵
{DATE \@ "dddd, d MMMM yyyy"}↵
{IF{MERGEFIELD State}<> 0 {QUOTE 12}}"}{IF{MERGEFIELD State}<> 0 "Director,↵
Retail Sales {MERGEFIELD State}{SET Key {MERGEFIELD State}}↵
↵
These are the sales totals for {MERGEFIELD State \* Charformat}↵
↵
City Representative Sales↵
"}"}"{IF{MERGEFIELD State}<> 0 "{MERGEFIELD City} {MERGEFIELD Representative} {MERGEFIELD Sales \# $,0.00}↵
"}"}¶
In the above, the:
• green content outputs whatever goes at the start of each letter.
• orange content outputs the repeated data.
• red content outputs whatever goes at the end of each letter (technically, {IF{MERGEFIELD State}<> 0 {QUOTE 12}} is part of that).
• blue QUOTE field generates the page breaks between letters.
• purple fields manage whatever you use as the KEY to indicate a change of grouping.
• black content does the housekeeping, pulling all the others together and ensuring you don't get output being generated at the wrong time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 02-03-2015, 07:18 AM
Keith Henderson Keith Henderson is offline Mailmerge with grouped data Windows 7 32bit Mailmerge with grouped data Office 2010 32bit
Novice
Mailmerge with grouped data
 
Join Date: Feb 2015
Posts: 9
Keith Henderson is on a distinguished road
Default

OK. Thanks. I'll start playing with it again this morning. Just to make sure I understand, the "Repeated data" in the orange fields represents the multiple rows of data I have for each key?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge with grouped data Exporting Grouped Shapes JamesEddy Word 4 12-08-2014 08:16 AM
Updating grouped ContentControls in Word 2010 MGerhard Word VBA 3 08-04-2014 02:34 AM
Directory MailMerge with Category Grouped Lists on Labels screech Mail Merge 3 06-18-2014 11:41 PM
Mailmerge with grouped data Mailmerge Data Format tombradley Mail Merge 1 09-29-2013 07:35 PM
Mailmerge with grouped data Excel data using mailmerge issue kilosub Mail Merge 12 05-05-2011 12:27 AM

Other Forums: Access Forums

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


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