Reply
 
Thread Tools Display Modes
  #1   Report Post  
derricklo1980 derricklo1980 is offline
Junior Member
 
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, 245 views)
  #2   Report Post  
derricklo1980 derricklo1980 is offline
Junior Member
 
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!
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with Excel - Date not Formatting Correctly [email protected][_2_] Microsoft Word Help 3 August 6th 15 07:02 PM
Mail Merge field not displayed correctly Mark Mailmerge 1 June 14th 09 04:34 AM
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 12:25 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"