View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default How do I repeat records in a mail merge?

{ IF { MERGEFIELD Course } = "" "" "{ SET myCourse { MERGEFIELD
Course }"}{ REF myCourse }

or conversely

{ IF { MERGEFIELD Course } "" "{ SET myCourse { MERGEFIELD Course }"}{
REF myCourse }

The line (and it is one line) checks to see if Course has content and if it
does, it adds its content to a bookmark 'MyCourse' and then the REF field
reproduces the content of the bookmark.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
I tried your code and it only prints the first one, the rest are all
blank. I noticed that there was one } missing so what I typed in is
this:

{ IF " { MERGEFIELD Course }" = ""
"" "{ SET myCourse { MERGEFIELD Course }"
}{REF myCourse}}

Do I have to have it broken up as you typed it or should it be all on
one line?

Also does the spacing between {} have to be as you typed it?



Peter Jamieson wrote:
It may be simpler than I assumed.

Let's suppose you have a column in your Excel sheet called Course
that is only filled in on the first row for each course.

In your Mailmerge main document, you could use

{ IF "{ MERGEFIELD Course }" = ""
"" "{ SET myCourse { MERGEFIELD Course }"
}{ REF myCourse }

where all the {} are the special field code braces you can insert
using ctrl-F9, not the ones you can type directly on the keyboard.

Peter Jamieson
wrote in message
ups.com...
Yes that's basically how I have it setup. I thought about filling
in course name and date for each candidate but I just wanted to see
if there was another way.