Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-02-2014, 02:56 PM
macropod's Avatar
macropod macropod is offline Mail Merge Formatting Phone numbers Windows 7 32bit Mail Merge Formatting Phone numbers Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your description suggests some of the phone numbers have been input into the Excel workbook with the hyphens, whilst others have not. Consequently, you have a mix of numeric and non-numeric data. That, in turn causes the mailmerge to read the non-numeric data as formulae (i.e. the second part of the phone # gets subtracted from the first part). The solution is to remove all the hyphens in Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Formatting Phone numbers can you change department field in phone numbers pspec Outlook 2 04-05-2014 02:51 AM
Mail Merge Formatting Phone numbers Extracting a phone number from a string that contains text and numbers. hommi16 Excel 2 06-05-2013 09:19 PM
Converting Phone Numbers Question certified_techy Excel 8 06-08-2012 02:27 AM
Create Custom Labels for Phone numbers Tonistep Outlook 0 03-26-2012 02:57 PM
Mail Merge Formatting Phone numbers Continuous page numbers with mail merge? Jennifer Murphy Mail Merge 1 08-11-2011 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 PM.


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