Microsoft Office Forums Inventory numbers missing in an Excel Merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2018, 10:11 AM
bearcublandon bearcublandon is offline Inventory numbers missing in an Excel Merge Windows 10 Inventory numbers missing in an Excel Merge Office 2016
Novice
Inventory numbers missing in an Excel Merge
 
Join Date: Dec 2018
Posts: 24
bearcublandon is on a distinguished road
Default

I have an Excel file that I've merged with Word using the Mail Merge Wizard.



This doesn't happen all the time but there are some instances where I have an inventory number coming from the Excel but the item being displayed in the Word Document is "0" - not the number in the Excel cell.

I've retyped the problem inventory numbers again in Excel (thinking there might be some foreign agent in the cell), saved/closed the Excel file and re-opened the Word Document.

Is this a common bug or is these something that I can do to fix it. I'm new to Word - though I've had classes on it, so I'm totally clueless as to how Mail Merge words, how to refresh the data, etc.

Is there a way to fix this problem

Thank you for your help,

Oh, I'm using a text box inside of table so the values appear at the bottom of the cell. Does using a text box create this issue?

Michael
Reply With Quote
  #2  
Old 12-20-2018, 02:35 PM
macropod's Avatar
macropod macropod is offline Inventory numbers missing in an Excel Merge Windows 7 64bit Inventory numbers missing in an Excel Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,538
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See Mailmerge Data Format Problems in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
Evidently, your Excel column has mixed data types.

As for the textbox, you should be able to achieve the same effect by setting the cell's vertical alignment to 'bottom'.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-20-2018, 02:50 PM
bearcublandon bearcublandon is offline Inventory numbers missing in an Excel Merge Windows 10 Inventory numbers missing in an Excel Merge Office 2016
Novice
Inventory numbers missing in an Excel Merge
 
Join Date: Dec 2018
Posts: 24
bearcublandon is on a distinguished road
Default

Yes, I think you're right. Most of the values are numeric but we had to include leading zeros on some of them. If I reformat them all as Text would that take care of the Issue?

Some leading number SKU's show as well.

thank you for the tip
Reply With Quote
  #4  
Old 12-20-2018, 04:04 PM
macropod's Avatar
macropod macropod is offline Inventory numbers missing in an Excel Merge Windows 7 64bit Inventory numbers missing in an Excel Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,538
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Formatting the Excel data as text will make no difference; you'll need to do as described in the link.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inventory numbers missing in an Excel Merge Inventory-Trying to add numbers to a total based on the numbers above. beeker223 Excel 13 07-17-2017 11:12 AM
Inventory numbers missing in an Excel Merge Barcode scanner inventory check with excel 2016 laure Excel 4 12-20-2016 07:10 PM
Inventory numbers missing in an Excel Merge missing some page numbers only those contain object from excel imeff Word 5 06-25-2015 01:12 AM
I need help with keeping an inventory organized w/ WORD or Excel? CeltFan09 Excel 2 05-04-2011 05:46 PM
Numbers Missing-HELP! ofriendasu Word 0 07-12-2010 03:08 PM


All times are GMT -7. The time now is 07:25 PM.


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