Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2012, 08:15 AM
fredsin fredsin is offline merge fields at bottom of document causing two pages Windows 7 64bit merge fields at bottom of document causing two pages Office 2012
Novice
merge fields at bottom of document causing two pages
 
Join Date: Mar 2012
Posts: 2
fredsin is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-14-2012, 05:18 PM
macropod's Avatar
macropod macropod is offline merge fields at bottom of document causing two pages Windows 7 64bit merge fields at bottom of document causing two pages Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 03-15-2012, 08:53 AM
fredsin fredsin is offline merge fields at bottom of document causing two pages Windows 7 64bit merge fields at bottom of document causing two pages Office 2012
Novice
merge fields at bottom of document causing two pages
 
Join Date: Mar 2012
Posts: 2
fredsin is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 03-15-2012, 02:21 PM
macropod's Avatar
macropod macropod is offline merge fields at bottom of document causing two pages Windows 7 64bit merge fields at bottom of document causing two pages Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
merge fields at bottom of document causing two pages Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
merge fields at bottom of document causing two pages Word Issue, bottom of document is showing on the screen several times. TerryBlevins Word 1 12-21-2011 12:58 AM
merge fields at bottom of document causing two pages 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
merge fields at bottom of document causing two pages create letter template with fixed position fields and follow up pages Lynn O'Shea Word 3 05-18-2010 12:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft