View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge fields WITHIN the text of IF-then-else

Use

{ IF { MERGEFIELD testfield } = "M" "in memory of { MERGEFIELD firstname }
{ MERGEFIELD lastname }etc." { IF { MERGEFIELD testfield } = "H" "in honour
of { MERGEFIELD firstname } { MERGEFIELD lastname }etc." "." } }

--
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

"Retread" wrote in message
...
First, thanks to Doug MVP and "Ed" for previous comments regarding MM.
Reading them almost got me the whole way through my "problem". Using
"Ed's"
suggestion from 4/5/2007, I tried to test one field three times :
if it's an "M" text should say "in memory of firstname lastname
(mergefields) then another sentence sending an acknowlegement,
if an "H", "in honor of firstname lastname, etc.
If blank, then put a period at the end of the preceding sentence.

I'm pretty new to this, and can't even figure out how to copy my actual
code
into this question - ctl F9 doesn't work within this question box and
doing
Edit, Copy, then Edit, Paste doesn't work either.
From the code I wrote by nesting Ed's statement (see above) here is what I
get :

in memory of . An acknowledgement will be sent as you requested.

MERGEFIELD FIRSTNAME MERGEFIELD LASTNAME fields (both bracketed by using
Ctl
F9) don't show up after "in memory of".

I'm pretty new to this, and can't even figure out how to copy my actual
code
into this question - ctl F9 doesn't work within this question box and
doing
Edit, Copy, then Edit, Paste doesn't work either. I can send it to you as
a
Word attachment if that would help.

Thanks - I'm sure this is simple but I'm stumped at the moment.