Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-28-2013, 12:16 PM
woody woody is offline mail merge treating CITY as DATE Windows XP mail merge treating CITY as DATE Office 2010 32bit
Novice
mail merge treating CITY as DATE
 
Join Date: Jan 2013
Posts: 4
woody is on a distinguished road
Default mail merge treating CITY as DATE


I have an odd one

I'm creating a mail merge to print out envelopes. The document is in Word2010, the database is Excel2010

all the other fields I merge are working fine, but one of my fields comes out in the Word Document as 12:00:00 AM even though the source data is a text field ( the city of the address )

I"ve tried ensuring that the Excel data is formatted text, I"ve tried fiddling with the format of the receiving field ( it is formatted just like the others )

help, Please
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge treating CITY as DATE Issue with date format in mail merge document walshjod Mail Merge 4 11-28-2012 04:46 AM
mail merge treating CITY as DATE Date picker mail merge error. dan1 Mail Merge 7 06-28-2012 03:00 AM
mail merge treating CITY as DATE Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
mail merge treating CITY as DATE treating text like an image gib65 Word 2 08-31-2011 07:20 PM
mail merge treating CITY as DATE Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM

Other Forums: Access Forums

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


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