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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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