Mergefield showing as time!

N

Notsoshie

I created a merge document which until yesterday was working beautifully.
Then suddenly, one of my mergefields went wonky.

The source document is an Excel file where the field value is either a date
or one of three different two-letter text fields depending on the record.

In the merge document, if the field value is a date, it's showing up
correctly in the document. If it is one of the two letter text fields, it's
showing up as a time, namely 12:00 AM.

I have checked and rechecked the source document, but the cells are
formatted correctly. I have checked the mergefield and it looks identical to
other mergefields that are working correctly. The help menu is absolutely no
help as I'm sure you can imagine.

I cannot figure out why this time is showing up or how to correct the
problem. Is there any help out there? I promised my boss I would get this
documented distributed company wide today! Please Help!!!
 

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

Grouping {MERGEFIELD} into 2 or 3 Columns 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Start a mail merge upon opening the document 1
Problem with SET & REF function 0
add mergefields to exsting word 2013 2
Mail Merge skipping records/sending one at a time 0
Auto Merge text from multiple sources 0
Page numbering with Merged Document and IF statements 1

Top