Home |
Search |
Today's Posts |
#15
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
If you use Alt-F9 to show the field codes in each gen?.doc, you would see
something like { MERGEFIELD Name } { MERGEFIELD Addr1 } { MERGEFIELD CPP } { MERGEFIELD Sal } . . . . then the body text. Assuming you want each of those MERGEFIELD lines to be removed when they are blank, you could use { IF { MERGEFIELD Name } = "" "" "{ MERGEFIELD Name } " }{ IF { MERGEFIELD Addr1 } = "" "" "{ MERGEFIELD Addr1 } " }{ IF { MERGEFIELD CPP } = "" "" "{ MERGEFIELD CPP } " } { IF { MERGEFIELD Sal } = "" "" "{ MERGEFIELD Sal } " } . . . . then the body text. As I've probably said before, each of the pairs of {} need to be the special field braces you can insert using ctrl-F9. Everything else is plain text. It doesn't really matter how you lay out the IF fields as long as there's a paragraph mark immediately after the { MERGEFIELD } in the result and the following text follows straight on. e.g. you can use { IF { MERGEFIELD Name } = "" "" "{ MERGEFIELD Name } " }{ IF { MERGEFIELD Addr1 } = "" "" "{ MERGEFIELD Addr1 } " }{ IF { MERGEFIELD CPP } = "" "" "{ MERGEFIELD CPP } " } but not { IF { MERGEFIELD Name } = "" "" "{ MERGEFIELD Name }" }{ IF { MERGEFIELD Addr1 } = "" "" "{ MERGEFIELD Addr1 }" }{ IF { MERGEFIELD CPP } = "" "" "{ MERGEFIELD CPP }" } or { IF { MERGEFIELD Name } = "" "" "{ MERGEFIELD Name } " } { IF { MERGEFIELD Addr1 } = "" "" "{ MERGEFIELD Addr1 } " } { IF { MERGEFIELD CPP } = "" "" "{ MERGEFIELD CPP } " } (I usually do it the first way because it has more chance of getting through these newsgroups unchanged) Peter Jamieson "Peter" wrote in message ... Hi Peter, I guess for me, the confusion is where to place the information about the actual fields in my Gen.doc within the If statement. I have 4 different documents to begin with; Gen, Gen2, Gen3, Gen4. Within each document I have 4 merge fields as so: Name Addr1 CPP Sal . . . . then the body text. The field "Alert" does not appear in the document but is only used as reference for type of letter. So in your example of: { IF "{ MERGEFIELD ALERT }"= "" "" "{ IF "{ MERGEFIELD ALERT }" = "GEN" "{INCLUDETEXT"C:\\Mer\\Gen.doc"}" "{MERGEFIELD ALERT} "}then stuff that should be on the next line I am confused about placement of the acutal data fields used in Gen, Gen2, Gen3, Gen4, to suppress blank lines. I will completely understand if you're getting frustrated with trying to get the concept through my thick skull . . . so feel free to throw your hands up and proclaim "what an idiot!" . . . lol Thanks again for your time Peter. Peter |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if statements with dates in mailmerge | Mailmerge | |||
How do I insert multiple hyperlinks in if, then, else statements? | Microsoft Word Help | |||
How do i use multiple IF statements in word 2000? | Mailmerge | |||
MERGE: Can I have multiple SET statements based on one IF | Mailmerge | |||
MERGE: Can I have multiple SET statements based on one IF | Mailmerge |