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 / August 2007

Tip: Looking for answers? Try searching our database.

Mail merge question about SKIPIF and NEXTIF

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
blingting - 21 Aug 2007 15:27 GMT
Hello,
How can we use mail merge in Microsoft Word in the following scenario:

There is a table of Data:

Condition    Name       Description
````````````     `````````       ```````````````
0               Name1      Description1
1               Name2      Description2
1               Name3      Description3
0               Name4      Description4
1               Name5      Description5

I want to use the records of the above data set in a document.
If the value of the Condition column in a given row is 0, then that row of
record will be skipped. If the Condition is 1, then it will be recorded. How
do we set it up within mail merge of Ms Word?

Please ask if you need more explaination.
Thanks.
Peter Jamieson - 21 Aug 2007 15:42 GMT
If you just need to process all records in the data source where Condition =
1, then you should be able to use the query options to do it. How to do that
depends on the version of Word, but in Word 2002 and later you need to get
to the Mail Merge Recipients dialog (which lists the data records), then
select the drop-down at the top of the COndition column - if there are only
two or three different values in the column you should see them listed, and
you can select "1". Otherwise, you may need to select the Advanced... option
in the dropdown and fill in the "Query Options" form that appears. In WOrd
2000 and earlier, you can get tot the Query Options form via the Mail Merge
Helper and fill it in. Although that should work in theory, sometimes the
query options dialog does not work properly, with some types of data source.

The other option would be to use a { SKIPIF } field at the top of the mail
merge main document. In this case, you could try

{ SKIPIF { MERGEFIELD Condition } = 0 }

or possibly

{ SKIPIF "{ MERGEFIELD Condition }" = "0" }

ALl the {} need to be the special field code braces that you can insert
using ctrl-F9

You can't always use SKIPIF successfully - for example, with a label merge,
you would need multiple SKIPIFs, one for each label, and the trouble then is
that the SKIPIF cancels the merge of the current copy of the document, i.e.
loses all previous labels on the current page.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hello,
> How can we use mail merge in Microsoft Word in the following scenario:
[quoted text clipped - 17 lines]
> Please ask if you need more explaination.
> Thanks.
blingting - 21 Aug 2007 16:45 GMT
That was very helpful brother.
Thanks a lot.

>If you just need to process all records in the data source where Condition =
>1, then you should be able to use the query options to do it. How to do that
[quoted text clipped - 30 lines]
>> Please ask if you need more explaination.
>> Thanks.
 
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.