(newbie) add Mail Merge

L

lake

Can anyone assist with a Macro this will add a
superscripted (th, st, nd, rd) to a date (field
name 'day') in a Mail Merge document. Can someone assist
 
D

DA

You don't need to use a VBA macro to do this.
Here's a field code, which you can add to the right of
your "day" mergefield.

Take care in copying the right syntax, as it's easy to
get a mistake in these. If you can't get it to work,
email me directly and I'll send you a Word file.

All the best,
Dennis

-------

{IF{=OR({MERGEFIELD "day"}=1,{MERGEFIELD "day"}=21)}
=1 "st" "{IF{=OR({MERGEFIELD "day" }=2,{MERGEFIELD "day"}
=22)}=1 "nd" "{IF{=OR({MERGEFIELD "day"}=3,
{MERGEFIELD "day"}=23)}=1 "rd" "{IF{MERGEFIELD "day"}
=31 "st" "th"}"}"}"}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top