12:00:00 AM

K

Keith4321

Suddenly "12:00:00 AM" appears in many of the fields in the Mail Merge
Recipients preview. It appears in all the "first name", "last name", "title"
and other fields. When I merge the document with the Excel data :12:00:00 AM"
merges into the docuement. Help?
 
P

Peter Jamieson

Which version of Word/Excel? Has anything obvious changed (e.g. upgrading to
Word 2003 SP3?)

For a temporary fix I would try the DDE option at
http://tips.pjmsn.me.uk/t0003.htm, or if the workbook is simple (e.g. all
data and no formulas, try exporting to .csv and re-importing into a brand
new workbook.

However, if you have done anything like
a. add rows which happen to have cells formaated as "date/time"
b. add 8 or more rows at the top of your sheet that have date/time values
in them (doesn't sound likely but you never know)

that's probably the cause of this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
excluding 12:00:00 AM from query results 4
Insert name and adress from a list in a word document 1
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
separating date and time 5
Null dates in Access as '12:00:00 AM' in Word mailmerge 2
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
Empty > 12:00:00 AM? 1

Top