IF... THEN... ELSE... rule to insert a Mailmerge Field

[SoonerLater]

I need to create a mailmerge with this logic.

IF [mergefield OKtoPublish = "True"]
THEN insert [mergefield PhoneNumber]
ELSE insert ""

The If... Then... Else rule system lets you insert TEXT, not mergefields. However, it is a mergefield that I need to insert.



This thread in the UK Access Programmers Forum states:

I'm using Word2003, embedded in the fundraising database Raiser's Edge (I know, I know - ::shudders:.

I am trying to formulate a field (I tried with a Word If...then...else field but I couldn't get it to work) that would conditionally insert a mail merge field (email address) if one of the other address fields was blank.

The problem is that the Word field if...then...else seems to only support plain text insertions. I tried editing the 'then' portion of the field after insertion with { MERGEFIELD email_address } in various forms, but I couldn't get it to work.

Found your post while having similar issues. I found a workaround that works great for me. Just run the "If...Then...Else" wizard and put everything you want in it except the { MERGEFIELD email_address } part (use placeholder text in the "Insert this text" box to make it easy to find )

Then show the sourcecode in the word document (Alt+F9)

Then insert the { MERGEFIELD email_address } field using the typical method of clicking on "Insert Field" on the ribbon.

I couldn't find a difference between my manual coding and the coding MSWord made, but theirs worked ?!?!?!?! So give it a try and see if it helps.

After a lot of Googling, this above quotes were all I could find.

I've tried (I think) to implement the suggested solution, but I'll be darned if I can make it work.

Any suggestions?