Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bill koeninger bill koeninger is offline
Junior Member
 
Posts: 1
Default mail merge using if compare and ranges of values

Help!

I am working on a document that needs to fill in text that is dependent on amount ranges in a single mergefield. I have three ranges of values and text associated with each.

The ranges are
0 - 417000
417001 - 650000
650001 and higher

I can get two of the three to work but not all three at once. Here's what I have:

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } 417001 } ) } = 1 "text1" "" }

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } 417000 650001 } ) } = 1 "text2" "" }

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } 650001 } ) } = 1 "text3" "" }

I have tried multiple iterations of the and but nothing seems to work.

Any suggestions? My head is starting to hurt from pounding it against this brick wall of a problem.
 
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
Can I compare more than two merge field values using =AND or =OR? Rhiannon Mailmerge 9 July 9th 09 03:34 PM
Mail Merge Wizard Named Excel Ranges Michael W Mailmerge 1 July 9th 08 10:14 AM
Mail-Merge with Varying Data-Ranges Lisa Mailmerge 1 June 13th 08 10:04 PM
Mail-Merge with Varying Data-Ranges Lisa Microsoft Word Help 1 June 13th 08 11:48 AM
Word 2003 Mail Merge will not print individual pages or Ranges Rick Mailmerge 4 July 29th 05 05:07 AM


All times are GMT +1. The time now is 10:14 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"