#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
Formatting the Excel data as text will make no difference; you'll need to do as described in the link.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |