Thread
:
How do I repeat records in a mail merge?
View Single Post
#
6
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
Posts: n/a
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.
Reply With Quote