Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-20-2018, 10:11 AM
bearcublandon bearcublandon is offline Windows 10 Office 2016
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,375
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:
http://www.msofficeforums.com/mail-m...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 Windows 10 Office 2016
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,375
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-Trying to add numbers to a total based on the numbers above. beeker223 Excel 13 07-17-2017 11:12 AM
Barcode scanner inventory check with excel 2016 laure Excel 4 12-20-2016 07:10 PM
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:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft