A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail Merge: cannot display the field in Excel correctly



 
 
Thread Tools Display Modes
  #1  
Old August 16th 12, 02:58 AM
derricklo1980 derricklo1980 is offline
Junior Member
 
First recorded activity by WordBanter: Jul 2012
Posts: 2
Default Mail Merge: cannot display the field in Excel correctly

Hi all, I use Word to do mail merge from an Excel source (both files as attached), I have no idea why some fields cannot display the correct values (0 is displayed in Word for some merge fields (USD$xx (Order)). Anything wrong in the Excel file?? Many thanks!!
Attached Files
File Type: zip mail merge.zip (47.1 KB, 31 views)
Ads
  #2  
Old August 17th 12, 03:25 AM
derricklo1980 derricklo1980 is offline
Junior Member
 
First recorded activity by WordBanter: Jul 2012
Posts: 2
Default

Quote:
Originally Posted by derricklo1980 View Post
Hi all, I use Word to do mail merge from an Excel source (both files as attached), I have no idea why some fields cannot display the correct values (0 is displayed in Word for some merge fields (USD$xx (Order)). Anything wrong in the Excel file?? Many thanks!!
After changing the formatting to number in the Excel cells, the mail merge in Word is working fine. Thanks!
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge field not displayed correctly Mark Mailmerge 1 June 14th 09 04:34 AM
Mail Merge with Excel - Date not Formatting Correctly [email protected][_2_] Microsoft Word Help 2 April 17th 08 05:19 PM
mail merge - text wont display correctly rascl Mailmerge 8 August 18th 06 07:00 PM
mail merge using Word and Excel doesn't work correctly enolalum Mailmerge 2 October 29th 05 08:27 PM
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM


All times are GMT +1. The time now is 06:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.