 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / October 2007Values will not keep format from Excel to Word xp mail merge
I need to merge grades from excel to a mailmerge document. In office 2000, the number held formating. In office xp, the help instructions say to format the value in word. There is NO ability in word to do that which I can find. Please fix. You fix. :) Tools-Options-View and choose field codes. Or hit Alt+F9. This shows you WHERE you change it. Go here to learn HOW: http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat ******************* ~Anne Troy www.piersontech.com www.mrexcel.com > I need to merge grades from excel to a mailmerge document. In office 2000, > the number held formating. In office xp, the help instructions say to format > the value in word. There is NO ability in word to do that which I can find. > Please fix. Thankyou, the suggestion does exactly what I want to show. > You fix. :) > Tools-Options-View and choose field codes. Or hit Alt+F9. This shows you [quoted text clipped - 13 lines] > find. > > Please fix. Thank you. This is exactly what I needed. > You fix. :) > Tools-Options-View and choose field codes. Or hit Alt+F9. This shows you [quoted text clipped - 13 lines] > find. > > Please fix. See http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I need to merge grades from excel to a mailmerge document. In office > 2000, the number held formating. In office xp, the help instructions > say to format the value in word. There is NO ability in word to do > that which I can find. Please fix. You link will not open. "Web site not responding". Please send an active link. > See http://www.gmayor.com/formatting_word_fields.htm > > > I need to merge grades from excel to a mailmerge document. In office > > 2000, the number held formating. In office xp, the help instructions > > say to format the value in word. There is NO ability in word to do > > that which I can find. Please fix. Your link will not open. Please reply with an active link > See http://www.gmayor.com/formatting_word_fields.htm > > > I need to merge grades from excel to a mailmerge document. In office > > 2000, the number held formating. In office xp, the help instructions > > say to format the value in word. There is NO ability in word to do > > that which I can find. Please fix. I have just clicked the link in the message and the page opened as expected. Try it again. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Your link will not open. Please reply with an active link > [quoted text clipped - 12 lines] >>> say to format the value in word. There is NO ability in word to do >>> that which I can find. Please fix. Works OK from here too. Peter Jamieson >I have just clicked the link in the message and the page opened as >expected. [quoted text clipped - 16 lines] >>>> say to format the value in word. There is NO ability in word to do >>>> that which I can find. Please fix. Could you please help me? I have been doing a mail merge from Excel to Word (2003). I have been reading alot of your posts on using the percentage field codes and I finally got that part to work with the merge. Now I have a problem with a syntax error. What I am doing it I have the following fields in Excel: Collateral Value, % Field, % Recoverable Cost. The Value in Collateral Value is taken by 70% to come up with the Recoverable cost. I have 7 different collateral types and values. Some customers may only need to use one of them while others need more up to the seven. The first calculations works fine for all of the customers, but after that, if there really is no collateral, I keep getting a syntax error. I will also include the formulas that I have entered. In the mail merge: { ={MERGEFIELD "M_RE C2"} * 100 \# "0% "} If this is anything you could help me with, I would greatly appreciate it. I apologize if you can't understand what it is that I am asking, but I can't figure out how to ask what I need. Thanks, Billie What is the Word field calculation that gives a syntax error? What is the content of the field(s) that makes up the calculation when the error occurs. ie what is the result of the individual field(s) without a formatting switch? If it helps, the macro at http://www.gmayor.com/export_field.htm will ensure your field construction is correctly reproduced to save copying errors. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Could you please help me? I have been doing a mail merge from Excel > to Word (2003). I have been reading alot of your posts on using the [quoted text clipped - 20 lines] > > Thanks, Billie |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.