Mail Merge: cannot display the field in Excel correctly

D

derricklo1980

Hi all, I use Word to do mail merge from an Excel source (both files a
attached), I have no idea why some fields cannot display the correc
values (0 is displayed in Word for some merge fields (USD$xx (Order))
Anything wrong in the Excel file?? Many thanks!

+-------------------------------------------------------------------
|Filename: mail merge.zip
|Download: http://www.wordbanter.com/attachment.php?attachmentid=144
+-------------------------------------------------------------------
 
D

derricklo1980

derricklo1980;493080 said:
Hi all, I use Word to do mail merge from an Excel source (both files a
attached), I have no idea why some fields cannot display the correc
values (0 is displayed in Word for some merge fields (USD$xx (Order))
Anything wrong in the Excel file?? Many thanks!!
Click to expand...

After changing the formatting to number in the Excel cells, the mai
merge in Word is working fine. Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge data for unique email Ids in one email 2
Combining Mail Merge and Content Control via use of Sectional Breaks 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Grouping Names in Mail Merge 0
Labels in Office Word 0
Mail merge hyperlink wrong results 0
Mail Merge - displaying a conditional number of decimals 5
Header Fotter challenge! 4

Top