mail merge treating CITY as DATE

woody · #1 01-28-2013, 12:16 PM

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

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