Reply
 
Thread Tools Display Modes
  #1   Report Post  
Hanif
 
Posts: n/a
Default Conditional mail merge

I am using Word 2002.

I have set up a word document to merge data from Excel.
In Word, I have a list of items as follows:

Amt if choose option 1: merge field 1
Amt if choose option 2: merge field 2
Amt if choose option 3: merge field 3

What I would like to do, is to put a conditional merge
for the line that has merge field 3. ie. eg if the merge
field 3 amount is greater than zero, then only do I want
that entire line to show up. Otherwise I would like to
see a blank line.

Any help would be appreciated
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Let's assume your merge field is called "mergefield3"

If you are using Word 2003 (and maybe 2002), try changing

{ MERGEFIELD mergefield3 }

to

{ MERGEFIELD mergefield3 \b "Amt if choose option 3" }

You may need to press Alt-F9 to see the underlying fields instead of
mergefield3 etc.

If you are using an earlier version of Word, you will need to use an IF
field, e.g.

{ IF "{ MERGEFIELD mergefield3 }" = "" "" "Amt if choose option 3 { MERGE
mergefield3 }" }

where you insert each pair of {} using ctrl-F9

Peter Jamieson

"Hanif" wrote in message
...
I am using Word 2002.

I have set up a word document to merge data from Excel.
In Word, I have a list of items as follows:

Amt if choose option 1: merge field 1
Amt if choose option 2: merge field 2
Amt if choose option 3: merge field 3

What I would like to do, is to put a conditional merge
for the line that has merge field 3. ie. eg if the merge
field 3 amount is greater than zero, then only do I want
that entire line to show up. Otherwise I would like to
see a blank line.

Any help would be appreciated



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
Mail merge - Word 2003/Access 2000 Russell Farr Mailmerge 7 March 24th 06 12:03 AM
How do I eliminate numerous "Mail Merge..." under my tool bar? JulieMae Microsoft Word Help 2 January 9th 05 10:45 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 03:45 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 01:31 PM


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