Mail Merge Data is Not Showing What is in the Database Field
I am trying to merge fields from an Excel database over to a Word document. One field has the customers work phone in it. The merged data always shows up as "0" instead of the phone number in the Excel cell. The column before and after the Work Phone field
has the customers Home Phone and Cell Phone and this data merges correctly. Any ideas on why the Work Phone column merges as "0" for every customer in the list?
Word determines the type of data in a field by the contents of the first couple of records in the data source. It sounds like Word may have determined that the work phone field is a text field and hence when it comes to a number in it, it does not handle
it correctly. Try putting a dummy record at the top of the data source in which the data in that field is numeric and see if that overcomes the problem.
Hope this helps, Doug Robbins - MVP Office Apps & Services (Word) dougrobbinsmvp@gmail.com It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.