[beaniebug7]

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?

[macropod[_2_]]

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?

[beaniebug7]

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?

.

[Doug Robbins - Word MVP]

Did you use Ctrl+F9 to insert each pair of the field delimiters { } in the
field construction and does you field construction match that given exactly?

--
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, originally posted via msnews.microsoft.com

"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?

.

[macropod[_2_]]

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?

.