Formating fields in mailmerge Word and Excel
Posted on 2011-02-28
When mailmerge Word and Excel documents I noticed that all Excel formatting was lost in the WOrd Mailmerge Output.
For example the €222,222.00 in Excel gives me a 222222 in the Word mailmerge document
I understood that I have to add something like \# "€,0.00" to the MERGEFIELD command
Do I have to do these formatting manually? or is there in interface in Word to do it ?
Is there a list with all the formating I need for my mailmerge ?
I need to format date fields, % field, text field, mony fields, ect....