 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2008mail 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”}} 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.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi! Newbie here. I read through all of the recent mail merge > questions and have my multiple transaction mail merge almost complete [quoted text clipped - 8 lines] > Salute}, {Mergefield Date_Posted}""{Mergefield Date_Posted}"}{Set > ID2{Mergefield "ID"}} 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 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 } } Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thank you so much for your advice. > [quoted text clipped - 7 lines] > message board has been so great for me; I truly appreciate your help. > thanks 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. > Have you set the document type to Directory/Catalog? If you want each > 'letter' to start on a new page then you probably need. [quoted text clipped - 18 lines] > > message board has been so great for me; I truly appreciate your help. > > thanks The document type can be set from the mailmerge toolbar http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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? [quoted text clipped - 30 lines] >>> page break here. This message board has been so great for me; I >>> truly appreciate your help. thanks You are wonderful! It worked beautifully! Thank you so much. I can't even tell you how grateful I am. Awesome. You are welcome :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > You are wonderful! It worked beautifully! Thank you so much. I > can't even tell you how grateful I am. > > Awesome.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.