 |
 | 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 / April 2008Formatting Merged items
I have two computers at work, one has office 2000 and the other has 2002. In office 2000 the imported information retains it's formatting to print the price tags for my products. However, in office 2002 the formatting is lost when the documents are merged. I'm trying to retain the formatting for the items numbers of (00-000-0) and then keep the $ symbol and two decimal places, however I can't find a way to do this. Please Help??!! Hi Heather, With the item number mergefield, press Shift-F9 to reveal the code, which should look something like {MERGEFIELD Item}. Add \# "00-000-0" to the field so that you get {MERGEFIELD Item \# "00-000-0"}. Press F9 to update the field. With the value mergefield, press Shift-F9 to reveal the code, which should look something like {MERGEFIELD Value}. Add \# $,0.00 to the field so that you get {MERGEFIELD Value \# $,0.00}. Press F9 to update the field. Then re-run your mailmerge. Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- >I have two computers at work, one has office 2000 and the other has 2002. In > office 2000 the imported information retains it's formatting to print the [quoted text clipped - 3 lines] > places, however I can't find a way to do this. > Please Help??!! That worked for the dollar amounts, however the -'s didn't show up in the item number i just ended up with spaces. > Hi Heather, > [quoted text clipped - 16 lines] > > places, however I can't find a way to do this. > > Please Help??!! Hi Heather, Try using \# "00'-'000'-'0" for the switch. Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > That worked for the dollar amounts, however the -'s didn't show up in the > item number i just ended up with spaces. [quoted text clipped - 19 lines] >> > places, however I can't find a way to do this. >> > Please Help??!!
|
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.