Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
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€}} |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: 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"}} |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
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" wrote: 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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: 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 |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
The document type can be set from the mailmerge toolbar
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: 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" wrote: 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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: 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 |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
You are wonderful! It worked beautifully! Thank you so much. I can't even
tell you how grateful I am. Awesome. |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge multiple transactions
You are welcome
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sarah wrote: You are wonderful! It worked beautifully! Thank you so much. I can't even tell you how grateful I am. Awesome. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge with multiple worksheets | Mailmerge | |||
mail merge multiple documents | Mailmerge | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Multiple entries in mail merge | Mailmerge | |||
import transactions from excel | Page Layout |