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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mail merge filter issue
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? |
#2
|
|||
|
|||
mail merge filter issue
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? |
#3
|
|||
|
|||
mail merge filter issue
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? . |
#4
|
|||
|
|||
mail merge filter issue
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? . |
#5
|
|||
|
|||
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? . |
Thread Tools | |
Display Modes | |
|
|