#1   Report Post  
B
 
Posts: n/a
Default Skip Record If?

Hi, I'm trying to set up a mail merge for labels in which there will be a
column in the data source saying either "Yes" or "No" net to each person's
name. For the type of mailing I am currently doing I want the people with
"No" to be skipped and not have a label printed out. I was trying to do this
using "Skip Record If", but this doesn't seem to work. I've tried it in both
Word XP and Word 2000 and I can't get it to work right. I am also using a
"Next Record" field in the label set up. Are these two fields incompatible
with each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do this?

Any information would be greatly appreciated. Thanks!
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be a
column in the data source saying either "Yes" or "No" net to each person's
name. For the type of mailing I am currently doing I want the people with
"No" to be skipped and not have a label printed out. I was trying to do this
using "Skip Record If", but this doesn't seem to work. I've tried it in both
Word XP and Word 2000 and I can't get it to work right. I am also using a
"Next Record" field in the label set up. Are these two fields incompatible
with each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do this?

Word 2000: click the "Mail merge..." button on the mail merge toolbar. Click
"Query options". Set up a filter to merge to only those records where this
particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels but the
first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

  #3   Report Post  
B
 
Posts: n/a
Default

Hi, Cindy, thanks for your response. I tried this approach in Word 2000
and it worked. How would you do it in Word XP? I didn't see the exact
same option there. Would you use the mail merge recipient list feature?
Thanks in advance for any help or information.


"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be a
column in the data source saying either "Yes" or "No" net to each person's
name. For the type of mailing I am currently doing I want the people with
"No" to be skipped and not have a label printed out. I was trying to do this
using "Skip Record If", but this doesn't seem to work. I've tried it in both
Word XP and Word 2000 and I can't get it to work right. I am also using a
"Next Record" field in the label set up. Are these two fields incompatible
with each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do this?

Word 2000: click the "Mail merge..." button on the mail merge toolbar. Click
"Query options". Set up a filter to merge to only those records where this
particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels but the
first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)


  #4   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?Qg==?=,

I tried this approach in Word 2000
and it worked. How would you do it in Word XP? I didn't see the exact
same option there. Would you use the mail merge recipient list feature?

You can go this route, yes. Click the arrow next to a field name, then choose
"Advanced". You'll find the same Query Options dialog box behind that :-)

Your other option would be to pull the Mail Merge... button out of
Tools/Customize/Commands; Category "All commands".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

  #5   Report Post  
B
 
Posts: n/a
Default

Hi, Cindy, I just wanted to say thanks for the information. I tried what you
suggested in Word XP and it worked fine. Thanks again!


"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I tried this approach in Word 2000
and it worked. How would you do it in Word XP? I didn't see the exact
same option there. Would you use the mail merge recipient list feature?

You can go this route, yes. Click the arrow next to a field name, then choose
"Advanced". You'll find the same Query Options dialog box behind that :-)

Your other option would be to pull the Mail Merge... button out of
Tools/Customize/Commands; Category "All commands".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)




  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Chris Stammers
 
Posts: n/a
Default Skip Record If?

Hello,

I have tried to use the function you listed below and I got an error message
saying that 'Word could not parse the query into a valid SQL string'. I don't
know what to do next. I am trying to get a letter not to print if one field
= "A" and another field = "DOWNGRADE TO STANDARD COVER" Can you suggest what
I might be doing wrong? I have tried using 'SKIP IF' however I don't know if
multiple SKiP IF statements in a document will work, so the filter function
seemed a better idea.

Thanks.
Chris

"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be a
column in the data source saying either "Yes" or "No" net to each person's
name. For the type of mailing I am currently doing I want the people with
"No" to be skipped and not have a label printed out. I was trying to do this
using "Skip Record If", but this doesn't seem to work. I've tried it in both
Word XP and Word 2000 and I can't get it to work right. I am also using a
"Next Record" field in the label set up. Are these two fields incompatible
with each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do this?

Word 2000: click the "Mail merge..." button on the mail merge toolbar. Click
"Query options". Set up a filter to merge to only those records where this
particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels but the
first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)


  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Skip Record If?

There is no reason why two SKIPIF statements immediately following one
another at the start of the letter should not work as you intend and worked
satisfactorily in my tests here.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWNGRADE TO STANDARD COVER"}
or depending on what else might be in field2 you could get away with using
the leading unique characters and a wildcard e.g.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWN*"}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Chris Stammers wrote:
Hello,

I have tried to use the function you listed below and I got an error
message saying that 'Word could not parse the query into a valid SQL
string'. I don't know what to do next. I am trying to get a letter
not to print if one field = "A" and another field = "DOWNGRADE TO
STANDARD COVER" Can you suggest what I might be doing wrong? I have
tried using 'SKIP IF' however I don't know if multiple SKiP IF
statements in a document will work, so the filter function seemed a
better idea.

Thanks.
Chris

"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be
a
column in the data source saying either "Yes" or "No" net to each
person's name. For the type of mailing I am currently doing I want
the people with "No" to be skipped and not have a label printed
out. I was trying to do this using "Skip Record If", but this
doesn't seem to work. I've tried it in both Word XP and Word 2000
and I can't get it to work right. I am also using a "Next Record"
field in the label set up. Are these two fields incompatible with
each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do
this?

Word 2000: click the "Mail merge..." button on the mail merge
toolbar. Click "Query options". Set up a filter to merge to only
those records where this particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels
but the first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)



  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Chris Stammers
 
Posts: n/a
Default Skip Record If?

Graham,

Thanks for your help. It must have been a data input issue instead, which is
easier to solve!

Thanks again.

Regards,
Chris

"Graham Mayor" wrote:

There is no reason why two SKIPIF statements immediately following one
another at the start of the letter should not work as you intend and worked
satisfactorily in my tests here.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWNGRADE TO STANDARD COVER"}
or depending on what else might be in field2 you could get away with using
the leading unique characters and a wildcard e.g.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWN*"}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Chris Stammers wrote:
Hello,

I have tried to use the function you listed below and I got an error
message saying that 'Word could not parse the query into a valid SQL
string'. I don't know what to do next. I am trying to get a letter
not to print if one field = "A" and another field = "DOWNGRADE TO
STANDARD COVER" Can you suggest what I might be doing wrong? I have
tried using 'SKIP IF' however I don't know if multiple SKiP IF
statements in a document will work, so the filter function seemed a
better idea.

Thanks.
Chris

"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be
a
column in the data source saying either "Yes" or "No" net to each
person's name. For the type of mailing I am currently doing I want
the people with "No" to be skipped and not have a label printed
out. I was trying to do this using "Skip Record If", but this
doesn't seem to work. I've tried it in both Word XP and Word 2000
and I can't get it to work right. I am also using a "Next Record"
field in the label set up. Are these two fields incompatible with
each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do
this?

Word 2000: click the "Mail merge..." button on the mail merge
toolbar. Click "Query options". Set up a filter to merge to only
those records where this particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels
but the first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)




  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Skip Record If?

FWIW, if you get this...

'Word could not parse the query into a valid SQL string'

it's probably because you entered some filter criteria via the Mail merge
Recipients/Query options dialog. When you use that dialog, Word sometimes
does not generate SQL that the appropriate data provider can understand, and
there are other problems with that approach as well.

Peter Jamieson

"Chris Stammers" wrote in message
...
Graham,

Thanks for your help. It must have been a data input issue instead, which
is
easier to solve!

Thanks again.

Regards,
Chris

"Graham Mayor" wrote:

There is no reason why two SKIPIF statements immediately following one
another at the start of the letter should not work as you intend and
worked
satisfactorily in my tests here.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWNGRADE TO STANDARD COVER"}
or depending on what else might be in field2 you could get away with
using
the leading unique characters and a wildcard e.g.

{SKIPIF {Mergefield field1} = "A"}{SKIPIF {Mergefield field2 \*Upper} =
"DOWN*"}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Chris Stammers wrote:
Hello,

I have tried to use the function you listed below and I got an error
message saying that 'Word could not parse the query into a valid SQL
string'. I don't know what to do next. I am trying to get a letter
not to print if one field = "A" and another field = "DOWNGRADE TO
STANDARD COVER" Can you suggest what I might be doing wrong? I have
tried using 'SKIP IF' however I don't know if multiple SKiP IF
statements in a document will work, so the filter function seemed a
better idea.

Thanks.
Chris

"Cindy M -WordMVP-" wrote:

Hi ?B?Qg==?=,

I'm trying to set up a mail merge for labels in which there will be
a
column in the data source saying either "Yes" or "No" net to each
person's name. For the type of mailing I am currently doing I want
the people with "No" to be skipped and not have a label printed
out. I was trying to do this using "Skip Record If", but this
doesn't seem to work. I've tried it in both Word XP and Word 2000
and I can't get it to work right. I am also using a "Next Record"
field in the label set up. Are these two fields incompatible with
each other? Something I read in Word 2000's online help seemed to
suggest that they are. If so what would be the best way to do
this?

Word 2000: click the "Mail merge..." button on the mail merge
toolbar. Click "Query options". Set up a filter to merge to only
those records where this particular field is "Yes" (or "No").

do NOT use Skip If; but you will need the Next field in all labels
but the first.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
footnote numbers skip Willibus Microsoft Word Help 3 January 6th 05 11:21 PM
Record Lengths and Page Breaks Dick W. Mailmerge 2 December 13th 04 01:11 PM
Word 2000 - Table - Create a new row for each record. Jeanne Moos Tables 1 December 2nd 04 12:02 AM
Mailmerge starts at wrong record Franc v/d Westelaken Mailmerge 1 December 1st 04 11:59 AM
Different graphic for each record Alex St-Pierre Mailmerge 1 November 30th 04 02:06 AM


All times are GMT +1. The time now is 10:25 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"