Microsoft Office Forums - View Single Post - [Solved] IF Statements for a several ranges of values using Mail Merge

Thread: [Solved] IF Statements for a several ranges of values using Mail Merge

View Single Post

Old

05-01-2019, 08:42 PM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2016

gmayor uses Office 2016

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,137

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

Your syntax is wrong - change to
{IF {MERGEFIELD PriorityScore } >= 15 "Very High" "{IF {MERGEFIELD PriorityScore } >= 10 "High" "{IF {MERGEFIELD PriorityScore } >= 5 "Medium" "{IF {MERGEFIELD PriorityScore } >= 1 "Low"}"}"}"}
which does work.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote