#1
|
|||
|
|||
merge fields at bottom of document causing two pages
Hello,
I need to include a series of IF statements at the bottom of a letter that inserts text based on a change in value for a mergefield. For example, if the mergefieldAppeal=Running event, I want the text to read "Running event tax deduction is $10." And if is doesn't, nothing. If the mergefieldAppeal= Walking Event, I want the text to read "Walking event tax deduction is $20." If it doesn't, nothing. And on and on. I want to add an unlimited number of these statements at the end of the letter, because we have many events. When the event that satisfies the IF statement is present as the Appeal, the text will appear for that event. So I have a string of IF statements like this: {IF{MERGEFIELD Appeal_Descrition}="Running Event" "Running event tax deduction is $10" ""}{IF{Mergefield Appeal_Description}="Walking Event" "Walking event tax decution is $20" ""}...and on.... This works just fine in placing the proper text on the change of the mergefield value, but since the merge strings run over onto the next page, Word is spitting out a two page document instead of consolidating it onto one. The placement of the merged text is just fine....but it still creates lines that run onto a second page. How do I avoid those extra lines from generating in the merged document? I've looked all over the web for an answer, but have yet to find one that addresses this particular type of spacing issue. Many thanks in advance for your help. |
#2
|
||||
|
||||
I answered this yesterday, at: http://www.office-forums.com/merge-f...-t2339832.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for the response. And strange that my post showed up on that other site. I did repost this to one other site...Word Banter.com. Maybe that created another post elsewhere, but I totally respect the posting ettiquette.
With my merge, for some reason Word leaves blank lines at the end of my document as far down as my merge language goes, which runs it off the page and onto a second page. I would have thought that your logic would apply, which is why this is so frustrating. So I'm trying to get rid of those extra lines from forming and have thus far been unsuccessful. |
#4
|
||||
|
||||
Hi fredsin,
Word Banter and a number of other sites (such as the one I gave a link to) simply replicate the long-defunct newsgroups that used to do what forums such as this one now do. Consequently, what you post on one site turns up on all those that still provide a front-end to those new groups. As for your merge, I'm assuming there were no manual line breaks or paragraph breaks between any of your IF statements. If so, the fact you're still seeing unwanted lines suggests you're only previewing the merge. You need to Finish/Execute the merge to, say, a new document before the output formatting can be relied upon.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
Word Issue, bottom of document is showing on the screen several times. | TerryBlevins | Word | 1 | 12-21-2011 12:58 AM |
Inserting pages at the end of a mail merge | morten_lysgaard | Mail Merge | 3 | 07-25-2011 11:19 PM |
delete blank pages from mail merge document | blusea | Word | 0 | 12-17-2010 06:10 PM |
create letter template with fixed position fields and follow up pages | Lynn O'Shea | Word | 3 | 05-18-2010 12:32 AM |