Thread: [Solved] IF Statement ASK Fill in
View Single Post
 
Old 12-08-2015, 05:28 AM
GaryG GaryG is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Dec 2015
Posts: 2
GaryG is on a distinguished road
Smile IF Statement ASK Fill in

We have a mail merge formula that uses an IF statement to ask for more information if a lookup matches a particular value.
{IF"Fullname"="Santa Claus"{ASK what"What do you want for Christmas?"\o}{Ref what \*MERGEFORMAT}"}
Whilst it does what we want it to do it asks for the information3 times before it does it i.e. the "What do you want for Christmas?" dialogue box pops up 3 times (not all at once). Any ideas on what is causing this?

Many thanks in advance

Gary
Reply With Quote