View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word Mail Merge - Go back to first record

Word is not really designed to do this type of merge, and in any case cannot
go backwards through the data set. What you *may* be able to do is store the
field content from the first record and use it later eg

{ IF{ Mergeseq } = 1 { Set A { MERGEFIELD Total} } }

do your stuff

{REF A}

--

Graham Mayor - Word MVP

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



Snow White wrote:
Hi

I am merging information from a form with subform into word 2007. I
am aware of the directory source but due to very finick formatting
requirements i prefer using the next record syntax to get information
from all the rows in the order detail subform.

However at the end of the document i want to fetch the total which
comes from the orders form. If i insert the total field i get no
value which is understandable because the next record takes the
cursor to the field with no value in the totals. Can i somehow tell
word to go back to the first record and fetch the totals value from
there.

I would really appreciate some advice/ work around.

Kind Regards
Snow White