Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I omit blank space in a document created with a template?
I'm pulling data from Excel for a high school student/family directory. Not
all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
#2
|
|||
|
|||
Use a conditional merge field: IF. There also are SKIPIF and NEXTIF merge
fields that might be useful to you, depending on exactly what you're doing. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I'm pulling data from Excel for a high school student/family directory. Not all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
#3
|
|||
|
|||
That sounds promising, but how do I find them, ie. what menu are they on? Do
I have to tell Word this when I select the merge field? How do I complete the condition? I guess it's {if{mergefield} then??? "Herb Tyson [MVP]" wrote: Use a conditional merge field: IF. There also are SKIPIF and NEXTIF merge fields that might be useful to you, depending on exactly what you're doing. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I'm pulling data from Excel for a high school student/family directory. Not all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
#4
|
|||
|
|||
I forgot to tell you, Herb, the merge fields are in a table, so the more
accurate question may be "is it possible to tell a table that, if the lines are blank, not to leave room for them, i.e. to pull the bottom edge of the table up to just below the last row with data in it? Thanks very much! "Herb Tyson [MVP]" wrote: Use a conditional merge field: IF. There also are SKIPIF and NEXTIF merge fields that might be useful to you, depending on exactly what you're doing. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I'm pulling data from Excel for a high school student/family directory. Not all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
#5
|
|||
|
|||
That complicates matters.
To answer your other question, the conditional fields can be found (among other places) on the Mail Merge toolbar -- look for the Insert Word Field tool. Would you be skipping records, or would you be suppressing fields? The SKIPIF and NEXTIF are both geared to skipping a record if certain criteria are met (such as a field being blank). The IF field can be used to selectively skip particular fields (or other text) if certain criteria are met. Is this what you're doing: Row 1 might contain two fields from a data record, row 2 might contain additional fields from the same data record, etc.? And if any given row's fields are all empty, you'd want to suppress that row? I'm not sure that would work. Because the "include this text if field=true" text is enclosed in quotes, and has to be inside field braces, I don't think so. I don't know of any way to have an IF field begin in one table cell and end in another. A lot depends on exactly what you're doing. You might need to make it a faux table to get it to work. Rather than an actual table, you might have text that's formatted with borders so it *looks* like it's part of the table, but isn't really. That way, it could be enclosed inside the IF field's quotes. It strikes me as complicated to set up, but I might be overcomplicating matters, not having seen exactly what you're trying to do. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I forgot to tell you, Herb, the merge fields are in a table, so the more accurate question may be "is it possible to tell a table that, if the lines are blank, not to leave room for them, i.e. to pull the bottom edge of the table up to just below the last row with data in it? Thanks very much! "Herb Tyson [MVP]" wrote: Use a conditional merge field: IF. There also are SKIPIF and NEXTIF merge fields that might be useful to you, depending on exactly what you're doing. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I'm pulling data from Excel for a high school student/family directory. Not all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
#6
|
|||
|
|||
You are being so helpful, I really appreciate it! I'm amazed at how big the
Word world is...I seem to have tunnel vision for my little project. The data is in Excel in columns. In Word, I have a table and am using "merge fields" to select columns from the Excel data. The columns a student's name, parents' names, street address, city, phone number, email, and a few more. Not all of the families have data in all of those columns. Everything is working fine except there is blank space on the page. For example, if a family doesn't want its address published, but only its names and phone numbers, it looks like this: STudent Jones Mr & Mrs Jones (503) 238-1111 As opposed to: Nancy Church xxxx SE Ash St Portland OR (503) 238-1111 I suspect that would be called suppressing fields, but i'm not sure. Would I be better off skipping the Word approach and just using Excel? If so, where do I start? Thank you so much! "Herb Tyson [MVP]" wrote: That complicates matters. To answer your other question, the conditional fields can be found (among other places) on the Mail Merge toolbar -- look for the Insert Word Field tool. Would you be skipping records, or would you be suppressing fields? The SKIPIF and NEXTIF are both geared to skipping a record if certain criteria are met (such as a field being blank). The IF field can be used to selectively skip particular fields (or other text) if certain criteria are met. Is this what you're doing: Row 1 might contain two fields from a data record, row 2 might contain additional fields from the same data record, etc.? And if any given row's fields are all empty, you'd want to suppress that row? I'm not sure that would work. Because the "include this text if field=true" text is enclosed in quotes, and has to be inside field braces, I don't think so. I don't know of any way to have an IF field begin in one table cell and end in another. A lot depends on exactly what you're doing. You might need to make it a faux table to get it to work. Rather than an actual table, you might have text that's formatted with borders so it *looks* like it's part of the table, but isn't really. That way, it could be enclosed inside the IF field's quotes. It strikes me as complicated to set up, but I might be overcomplicating matters, not having seen exactly what you're trying to do. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I forgot to tell you, Herb, the merge fields are in a table, so the more accurate question may be "is it possible to tell a table that, if the lines are blank, not to leave room for them, i.e. to pull the bottom edge of the table up to just below the last row with data in it? Thanks very much! "Herb Tyson [MVP]" wrote: Use a conditional merge field: IF. There also are SKIPIF and NEXTIF merge fields that might be useful to you, depending on exactly what you're doing. -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. "anjajane" wrote in message ... I'm pulling data from Excel for a high school student/family directory. Not all families have data in all merge fields, and the document is full of blank space when there is no date. How do I get the template to recognize that it should not leave this blank space in the document? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Document is not blank when Word 2003 is opened | Tables | |||
remove a blank sheet 2 from a document | Page Layout | |||
Have can i reverse a saved blank document in word? | Microsoft Word Help | |||
WORD WILL NOT BRING UP NEW BLANK DOCUMENT | Microsoft Word Help | |||
How do I remove excess blank pages from a finished document? | Microsoft Word Help |