Solved

Formating fields in mailmerge Word and Excel

Posted on 2011-02-28
4
307 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
  • 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 500 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

762 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now