mail merge multiple transactions

[Sarah]

Hi! Newbie here. I read through all of the recent mail merge questions and
have my multiple transaction mail merge almost complete except two things.

I an annoying page break that jumps in between my record listings AND if I
add any kind of textbox or image around all of the code it likes to add
another page break. Can anyone help? Here is my code:

{If {Mergeseq}=1 “â€â€â€}{Set ID1 {Mergefield “IDâ€}} {IF
{ID1}<>{ID2}â€{Mergefield FName} {MergeField LName} Dear {Mergefield Salute},
{Mergefield Date_Posted}â€â€{Mergefield Date_Posted}â€}{Set ID2{Mergefield “IDâ€}}

 

[Graham Mayor]

It is impossible to determine what you are trying to do with this field
construction. What, for example, is
{IF {Mergeseq}=1 """"} supposed to achieve? Then you have set a value for
the bookmark ID1 which you are comparing to a bookmark ID2 which is not
defined until later? I would be surprised any of it works at all?

I think you need to start by reading -
http://support.microsoft.com/?kbid=294686 which I guess is close to what you
are trying to achieve.

If you wish to post field constructions and avoid the inevitable problems of
typing them manually eg with smart quotes, then use the macro at
http://www.gmayor.com/export_field.htm to convert them to text directly from
your document.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Sarah]

Thank you so much for your advice.

I had referenced that same page when I put together the script. The only
thing that is missing from mine is the MergeField City portion which is why
there are 4 quotes in a row. It does work and the only problem I am having
is an page break is insert between the listing of the dates. For example, if
a person has two transactions the first one is listed and then there is a
page break and the second one is listed. I don't understand why I am getting
page break here. This message board has been so great for me; I truly
appreciate your help.
thanks

 

[Graham Mayor]

Have you set the document type to Directory/Catalog? If you want each
'letter' to start on a new page then you probably need.

{ IF{ Mergeseq } = "1" "{ Mergefield FName } { Mergefield LName }
Dear { Mergefield Salute },"}{ SET ID1 { MERGEFIELD ID } }{ IF { ID1 } <>
{ ID2 } " ***PAGE BREAK***
{ Mergefield FName } { Mergefield LName }
Dear { Mergefield Salute },
{ Mergefield DatePosted }" "
{ Mergefield DatePosted }" }{ Set ID2 { Mergefield ID } }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Sarah]

Thanks again for your quick reply! I think I shifted the fields around to
what you specified but how do you set the document type?
Also, the break in question is a section break NOT a page break.

 

[Graham Mayor]

The document type can be set from the mailmerge toolbar
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Sarah]

You are wonderful! It worked beautifully! Thank you so much. I can't even
tell you how grateful I am.

Awesome.

 

[Graham Mayor]

You are welcome

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>