Can't Seem To Get It To Work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Koerner - 25 Mar 2007 15:57 GMT

Using Office 2003 SP(2) trying to use the mailmerge feature to create two
sets of labels using Excel as the data source

I would like to be able to create a set of labels where the Country =
Canada, and a set of labels where the Country <> Canada, both using the
same excel spreadsheet.

I have tried using the SKIPIF command. I have worded the two templates like
this

{SKIPIF { MERGEFIELD Country = "Canada" }}
Rest of merge information

{SKIPIF { MERGEFIELD Country <> "Canada" }}
Rest of merge information

For some reason when I use the template (= Canada) I get no labels with any
information at all. When I use the second one (<> Canada) I get all the
labels both Canada and US

Which brings me to the end of my mailmerge knowledge. any suggestions would
be greatly appreciated.

Signature

Regards
Michael Koerner

Reply to this Message

Peter Jamieson - 25 Mar 2007 16:30 GMT

SKIPIF doesn't work with label merges because it doesn't do what you
probably expect (which is simply to SKIP a record) - what it actually does
is SKIP to the next record, stop processing the current copy of the mail
merge main document, and start processing a new copy of the mail merge main
document.

What you really need to do is filter the records for each merge - I would
enable the MailMerge toolbar (Tools|Customize) then open the Mail Merge
recipients (3rd button from the left), click the drop-ddown at the top of
the Country column, then either select "Canada" (if you see it), or click
Advanced... and set a filter Country Equal to Canada. Then close the dialog
boxes, save the mail merge main document (e.g. as Canada.doc). Re-open,
check it merges correctly. Then do the same thing, set a filter to Country
Not Equal To Canada, save as NotCanada.doc.

Peter Jamieson

> Using Office 2003 SP(2) trying to use the mailmerge feature to create two
> sets of labels using Excel as the data source
[quoted text clipped - 18 lines]
> Which brings me to the end of my mailmerge knowledge. any suggestions
> would be greatly appreciated.

Reply to this Message

Michael Koerner - 25 Mar 2007 16:50 GMT

Thanks Peter, will give it a try. Do I have to set it for each label on the
page? Dumb question I know.

Signature

Regards
Michael Koerner

> SKIPIF doesn't work with label merges because it doesn't do what you
> probably expect (which is simply to SKIP a record) - what it actually does
[quoted text clipped - 34 lines]
>> Which brings me to the end of my mailmerge knowledge. any suggestions
>> would be greatly appreciated.

Reply to this Message

Michael Koerner - 25 Mar 2007 17:09 GMT

Disregard the dumb question. Your suggestion worked like a charm. Thank you
very much.

Signature

Regards
Michael Koerner

> Thanks Peter, will give it a try. Do I have to set it for each label on
> the page? Dumb question I know.
[quoted text clipped - 37 lines]
>>> Which brings me to the end of my mailmerge knowledge. any suggestions
>>> would be greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 25 Mar 2007 16:33 GMT

For Starters,

{SKIPIF { MERGEFIELD Country = "Canada" }}

should be

{SKIPIF { MERGEFIELD Country } = "Canada" }

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

Reply to this Message

Michael Koerner - 25 Mar 2007 16:49 GMT

Should be is what I do have. Just mistyped when I created the post

Signature

Regards
Michael Koerner

> For Starters,
>
[quoted text clipped - 26 lines]
>> Which brings me to the end of my mailmerge knowledge. any suggestions
>> would be greatly appreciated.

Reply to this Message