Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-15-2012, 08:30 PM
derricklo1980 derricklo1980 is offline Mail Merge: cannot display the field in Excel correctly Windows XP Mail Merge: cannot display the field in Excel correctly Office 2007
Novice
Mail Merge: cannot display the field in Excel correctly
 
Join Date: Aug 2012
Posts: 4
derricklo1980 is on a distinguished road
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 instead in Word for some merge fields (USD$xx (Order)). Anything wrong in the Excel file?? Many thanks!!
Attached Files
File Type: doc doc1.doc (13.8 KB, 1 views)
File Type: xlsx Book1.xlsx (40.1 KB, 6 views)
Reply With Quote
  #2  
Old 08-15-2012, 09:46 PM
macropod's Avatar
macropod macropod is offline Mail Merge: cannot display the field in Excel correctly Windows 7 64bit Mail Merge: cannot display the field in Excel correctly Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,058
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Your currency values have all been input as text. You can see this from the fact they're right-aligned and are prefixed with '. Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.

You can remedy the problem by inputting a 1 in an unused cell, copying it, then selecting the blocks of numeric text and using Paste Special > Values > Multiply.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 08-15-2012, 10:37 PM
derricklo1980 derricklo1980 is offline Mail Merge: cannot display the field in Excel correctly Windows XP Mail Merge: cannot display the field in Excel correctly Office 2007
Novice
Mail Merge: cannot display the field in Excel correctly
 
Join Date: Aug 2012
Posts: 4
derricklo1980 is on a distinguished road
Default

But may I know why some cells can be displayed in Word normally in mail merge while some (with the same format) cannot?
Reply With Quote
  #4  
Old 08-16-2012, 12:05 AM
macropod's Avatar
macropod macropod is offline Mail Merge: cannot display the field in Excel correctly Windows 7 64bit Mail Merge: cannot display the field in Excel correctly Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,058
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

As I said:
Quote:
Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.
If you want to know the gory details, see 'How the OLE DB determines the data type for a column' at: http://tips.pjmsn.me.uk/t0003.htm
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 08-16-2012, 12:38 AM
macropod's Avatar
macropod macropod is offline Mail Merge: cannot display the field in Excel correctly Windows 7 64bit Mail Merge: cannot display the field in Excel correctly Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,058
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Cross-posted at: http://www.techsupportforum.com/foru...ly-660954.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 08-16-2012, 07:15 PM
derricklo1980 derricklo1980 is offline Mail Merge: cannot display the field in Excel correctly Windows XP Mail Merge: cannot display the field in Excel correctly Office 2007
Novice
Mail Merge: cannot display the field in Excel correctly
 
Join Date: Aug 2012
Posts: 4
derricklo1980 is on a distinguished road
Default

Thanks a lot.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
time field issue in mail merge Aude Mail Merge 16 05-18-2014 06:22 AM
Import field from Excel to Powerpoint xgravity23 Office 8 11-22-2012 02:08 PM
Mail Merge: cannot display the field in Excel correctly Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Mail Merge: cannot display the field in Excel correctly currency not showing correctly on mail merge tonywatsonmail Mail Merge 1 12-07-2011 04:29 PM
Mail Merge: cannot display the field in Excel correctly Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM


All times are GMT -7. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft