Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word 2000-Hiding static data
Hello
I have created a Word Mail Merge document that has been formatted using tables, the tables have been formatted to show lines. Within the tables there are a couple of columns that have static data for each row. My problem is when I perform the merge all of my formatted table including the lines and static text are printed, (as you would expect to happen) I want the rows of data not to be printed if there is no resulting data. I have tried an If, Then, Else €“ but to no avail. Can anyone help me please. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word 2000-Hiding static data
Just how have you tried an If...then...Else?
Without a bit more information, it is not possible to really help you. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Scoobs" wrote in message ... Hello I have created a Word Mail Merge document that has been formatted using tables, the tables have been formatted to show lines. Within the tables there are a couple of columns that have static data for each row. My problem is when I perform the merge all of my formatted table including the lines and static text are printed, (as you would expect to happen) I want the rows of data not to be printed if there is no resulting data. I have tried an If, Then, Else - but to no avail. Can anyone help me please. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word 2000-Hiding static data
Hi Doug
Sorry if I did not give enough information - I will attempt to elaborate: I am using Mail Merge to produce new documents for each Test script that has been created. The majority of the document is made up of tables which have been formatted with lines. The first column is made up of sequential numbering for each row and the last column has static text. Thereafter each row has information entered from the source data to enter the script text. The issue I have is that each table has been created to hold 10 rows, but not each test script holds 10 rows of data, therefore when the merge has been done - and the test script only has, lets say, 4 steps, the remainder of the formatted table and text still remain, but are mainly empty. I have tried to use an 'If' on the sequential numbering column, whereby if one of the data cells is empty - the sequential cell should be blank. This has not worked (but more than likely I have done it incorrectly). In addition, when the merge has been completed, the formatting of the original document is lost, I have amended the macro to use the same template, but this makes no difference. Hopefully the above gives you a little more information, it is difficult not to be able to add a screen shot to show you, but any advice you could give me would be much appreciated. Regards SUe "Doug Robbins - Word MVP" wrote: Just how have you tried an If...then...Else? Without a bit more information, it is not possible to really help you. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Scoobs" wrote in message ... Hello I have created a Word Mail Merge document that has been formatted using tables, the tables have been formatted to show lines. Within the tables there are a couple of columns that have static data for each row. My problem is when I perform the merge all of my formatted table including the lines and static text are printed, (as you would expect to happen) I want the rows of data not to be printed if there is no resulting data. I have tried an If, Then, Else - but to no avail. Can anyone help me please. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word 2000-Hiding static data
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://cornell.veplan.net/article.aspx?&a=3815 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Scoobs" wrote in message ... Hi Doug Sorry if I did not give enough information - I will attempt to elaborate: I am using Mail Merge to produce new documents for each Test script that has been created. The majority of the document is made up of tables which have been formatted with lines. The first column is made up of sequential numbering for each row and the last column has static text. Thereafter each row has information entered from the source data to enter the script text. The issue I have is that each table has been created to hold 10 rows, but not each test script holds 10 rows of data, therefore when the merge has been done - and the test script only has, lets say, 4 steps, the remainder of the formatted table and text still remain, but are mainly empty. I have tried to use an 'If' on the sequential numbering column, whereby if one of the data cells is empty - the sequential cell should be blank. This has not worked (but more than likely I have done it incorrectly). In addition, when the merge has been completed, the formatting of the original document is lost, I have amended the macro to use the same template, but this makes no difference. Hopefully the above gives you a little more information, it is difficult not to be able to add a screen shot to show you, but any advice you could give me would be much appreciated. Regards SUe "Doug Robbins - Word MVP" wrote: Just how have you tried an If...then...Else? Without a bit more information, it is not possible to really help you. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Scoobs" wrote in message ... Hello I have created a Word Mail Merge document that has been formatted using tables, the tables have been formatted to show lines. Within the tables there are a couple of columns that have static data for each row. My problem is when I perform the merge all of my formatted table including the lines and static text are printed, (as you would expect to happen) I want the rows of data not to be printed if there is no resulting data. I have tried an If, Then, Else - but to no avail. Can anyone help me please. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge can't find data source in Office XP...but it could in 2000! | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
How can I add data fields to a data source in Word Mail Merge? | Mailmerge | |||
How do I make footnote numners static in a mail merge document? | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge |