Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Formating fields in mailmerge Word and Excel

Posted on 2011-02-28
4
Medium Priority
?
318 Views
Last Modified: 2012-05-11
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
Comment
Question by:gadsad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 18

Expert Comment

by:Cluskitt
ID: 34998547
In word, either hit ALT+F9 to view field codes, or right click the field, edit field, then show codes.
0
 
LVL 18

Accepted Solution

by:
Cluskitt earned 2000 total points
ID: 34998573
0
 

Author Closing Comment

by:gadsad
ID: 35047372
thank you
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 35054896
Glad to help :)
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question