Thread: [Solved] mail merge treating CITY as DATE
View Single Post
 
Old 01-28-2013, 12:16 PM
woody woody is offline Windows XP Office 2010 32bit
Novice
  
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