Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Eliminating a value in a mail merge

Matching an exact text is straightforward - just use the whole text instead
of the single word example I gave before. If the text is the same apart from
capitalisation you can use the appropriate \* switches in your MERGEFIELD
field to make the text upper or lower case.

You can also use wildcards to a limited extent, e.g.

{ IF { MERGEFIELD myfield } = "*blank" "x" "y" } should give you "x" if
myfield contains your sample text. You can also do
{ IF { MERGEFIELD myfield } = "something*" "x" "y" } but you can't achieve a
"contains" using

{ IF { MERGEFIELD myfield } = "*something*" "x" "y" }

It doesn't work. Also, you may find that matching only works on relatively
short texts up to 128 characters. There's more about this in Word Help.

Peter Jamieson


wrote in message
ups.com...
The field contains a statement "This field intentionally left blank". I
am merging many fields and this is just one of them. I don't want to
skip the record, I just want to print nothing if this is in the field.
Myrna



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
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM


All times are GMT +1. The time now is 01:30 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"