View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default mail merge filter issue

Hi beaniebug7,

The same approach works for all Office versions, from '97 onwards. Do note that you need to pay careful attention to the spacing -
especially the space after the ''.

--
Cheers
macropod
[Microsoft MVP - Word]


"beaniebug7" wrote in message ...
Hi there!!!

thank you for the response, but i still can't get it to work - i'm using
office 7 - does that make a difference? i'm not sure what i doing wrong

beaniebug confusion

"macropod" wrote:

Hi beaniebug7,

You could use a SKIPIF field in the mailmerge main document coded along the lines of:
{SKIPIF{MERGEFIELD Last_Name} "{FILLIN "Output records for Last Names beginning with" \o}*"}
This will allow you to merge all records for last lames beginning with 'S', for example, or beginning with 'Mc', etc.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.


--
Cheers
macropod
[Microsoft MVP - Word]


"beaniebug7" wrote in message ...
i'm trying to filter a list by the first letter of the last name, but the
filter in word does not give the option "begins with" - any other ways to
accomplish this?


.