convert numbers from data to text in Word

[George]

I hope someone can help. I have an Excel sheet with a column of numbers (12,
26, 24 or 52). I want the mailmerge to populate my template with a word (ie.
12 - "monthly", 26 - "bi-weekly", 24 - "semi-monthly", 52 - "weekly").
Is this possible or do I have to change the data sheet before merging?

Thanks!

 

[Peter Jamieson]

You can do it in Word by using e.g.

{ IF { MERGEFIELD frequency } = 12 "monthly" ""
}{ IF { MERGEFIELD frequency } = 26 "bi-weekly" ""
}{ IF { MERGEFIELD frequency } = 24 "semi-monthly" ""
}{ IF { MERGEFIELD frequency } = 52 "weekly" "" }

Where all the {} are the special field code braces you can insert using
Ctrl-F9. (Use Alt-F9 to toggle been "field view" and "results view"

Peter Jamieson

http://tips.pjmsn.me.uk

 

[George]

That's awesome, thanks!

You can do it in Word by using e.g.

{ IF { MERGEFIELD frequency } = 12 "monthly" ""
}{ IF { MERGEFIELD frequency } = 26 "bi-weekly" ""
}{ IF { MERGEFIELD frequency } = 24 "semi-monthly" ""
}{ IF { MERGEFIELD frequency } = 52 "weekly" "" }

Where all the {} are the special field code braces you can insert using
Ctrl-F9. (Use Alt-F9 to toggle been "field view" and "results view"

Peter Jamieson

http://tips.pjmsn.me.uk