Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

Formating fields in mailmerge Word and Excel

Hello,

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....

Thank you...

 
0
gadsad
Asked:
gadsad
  • 3
1 Solution
 
CluskittCommented:
In word, either hit ALT+F9 to view field codes, or right click the field, edit field, then show codes.
0
 
CluskittCommented:
0
 
gadsadAuthor Commented:
thank you
0
 
CluskittCommented:
Glad to help :)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now