Microsoft Office Forums Mail merge number fields outputting inconsistently

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2011, 04:46 AM
rekcots rekcots is offline Mail merge number fields outputting inconsistently Windows 2K Mail merge number fields outputting inconsistently Office 2003
Novice
Mail merge number fields outputting inconsistently
 
Join Date: May 2011
Posts: 2
rekcots is on a distinguished road
Default Mail merge number fields outputting inconsistently

Hello

I'm trying to complete an email mail merge where some of the fields have telephone numbers in. The data source is an Excel spreadsheet.

I've formatted the telephone merge fields in the following format \# "0000 000 0000". The telephone numbers output correctly for some of the telephone numbers but not for all the records. For example some output as 0000 000 4642 which is incorrect.



The phone numbers are all in the same format in the Excel spreadsheet I am using. Does anyone have any suggestions as to how I can correct this?

Thanks
R
Reply With Quote
  #2  
Old 05-18-2011, 05:38 AM
macropod's Avatar
macropod macropod is offline Mail merge number fields outputting inconsistently Windows 7 32bit Mail merge number fields outputting inconsistently Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,648
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

Hi Rekcots,

What do you get when you output the problem fields without the switch? I suspect you'll find that, in Excel, some have been input as text, with the formatting as part of the input data, whereas other have been input as numbers with the formatting applied via Excel's formatting tools.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-18-2011, 06:32 AM
rekcots rekcots is offline Mail merge number fields outputting inconsistently Windows 2K Mail merge number fields outputting inconsistently Office 2003
Novice
Mail merge number fields outputting inconsistently
 
Join Date: May 2011
Posts: 2
rekcots is on a distinguished road
Default

Hi Paul

Thanks for the explanation.

You were right as not all cells were in the same format. I've converted them to text and the merge output is working now.

Thanks for your help,

R
Reply With Quote
Reply

Tags
mail merge, numbers

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge number fields outputting inconsistently Mail Merge truncating 'some' of the text fields......Not sure what to do sssb2000 Mail Merge 5 09-26-2010 09:40 AM
Mail Merge question: Using fields connected to a CSV file in Word 2007 Mr_Luke Mail Merge 0 06-18-2010 10:11 AM
How do I set up the fields in mail merge word 07 from my data base mbcrabber Mail Merge 4 06-06-2010 01:25 PM
Mail Merge Fitting Text to Fields frnk4760 Mail Merge 1 05-18-2010 04:51 PM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM


All times are GMT -7. The time now is 03:37 AM.


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