Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

Mail Merge in Word 2000-Hiding static data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scoobs - 19 Mar 2007 15:33 GMT
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.
Doug Robbins - Word MVP - 19 Mar 2007 22:18 GMT
Just how have you tried an If...then...Else?

Without a bit more information, it is not possible to really help you.

Signature

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

> Hello
>
[quoted text clipped - 10 lines]
>
> Can anyone help me please.
Scoobs - 20 Mar 2007 09:42 GMT
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

> Just how have you tried an If...then...Else?
>
[quoted text clipped - 14 lines]
> >
> > Can anyone help me please.
Doug Robbins - Word MVP - 20 Mar 2007 09:56 GMT
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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://cornell.veplan.net/article.aspx?&a=3815

Signature

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

> Hi Doug
>
[quoted text clipped - 56 lines]
>> >
>> > Can anyone help me please.
 
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.