![]() |
|
|
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
Quote:
Quote:
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}↵
"}"}¶
• 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] |
|
#3
|
|||
|
|||
|
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?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
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 Data Format
|
tombradley | Mail Merge | 1 | 09-29-2013 07:35 PM |
Excel data using mailmerge issue
|
kilosub | Mail Merge | 12 | 05-05-2011 12:27 AM |