A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail merge question about SKIPIF and NEXTIF



 
 
Thread Tools Display Modes
  #1  
Old August 21st 07, 03:28 PM posted to microsoft.public.word.mailmerge.fields
blingting
external usenet poster
 
Posts: 3
Default Mail merge question about SKIPIF and NEXTIF

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.

Ads
  #2  
Old August 21st 07, 03:42 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Mail merge question about SKIPIF and NEXTIF

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.

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

"blingting" [email protected] wrote in message news:[email protected]
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.


  #3  
Old August 21st 07, 04:45 PM posted to microsoft.public.word.mailmerge.fields
blingting
external usenet poster
 
Posts: 3
Default Mail merge question about SKIPIF and NEXTIF

That was very helpful brother.
Thanks a lot.

Peter Jamieson wrote:
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.

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge question Suki Mailmerge 5 February 19th 07 04:20 PM
Mail merge question rfikes Mailmerge 2 November 27th 06 03:05 PM
Mail Merge Question Kurch Mailmerge 6 May 8th 06 01:53 AM
Mail Merge Question NKYBred Microsoft Word Help 0 October 5th 05 03:11 PM
Merge error when SkipIf added vanessa Mailmerge 2 July 1st 05 06:30 PM


All times are GMT +1. The time now is 07:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.