I am having a difficult time formatting time in my mail merge document.



I have a column in my excel database database "starts". It contains a date value formatted as "h:mm AM/PM"

In my mailmerge document, I wish to use "starts" as a mail merge field to display time in the same format. I have used this:
{MERGEFIELD "STARTS" \@"h:mm AM/PM" }

But this just gives me decimals in my maile merged document.

Do you have anything other than times in that column?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul, thanks for stepping up with assistance.
This issue, as well as the one posted here
https://www.msofficeforums.com/mail-...y-newpost.html
appears to be unique to my home computer. These problems, as well as other odd mail merge deficiencies I am unable to replicate on my office computer. Everything works perfect on my work computer.

Aside from the issues discussed in the other thread, the behaviour may differ if you have the workbook open while doing the merge (I think we've discussed this before).

Just to eliminate any faults in Word or Excel, you might try repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks again Paul ...
Whether on my home or work computer, the data source (workbook) is always open while doing the merge.


I'll try a repair, but this is a relatively new reinstall (1 month or so) after a new hard drive install. Not saying it might not need a repair, but would wonder whats breaking it with every installation I do.