#1
|
|||
|
|||
Help Formatting Time in A MailMerge Field
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. |
#2
|
||||
|
||||
Do you have anything other than times in that column?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mailmerge, show region only the first time. | takamaz | Mail Merge | 3 | 02-26-2018 05:13 PM |
Mailmerge field format? | Rothera85 | Mail Merge | 9 | 05-11-2014 03:41 PM |
Mailmerge printing with field names | Jvallee | Mail Merge | 9 | 04-16-2014 06:30 PM |
Yes/No field does not work in mailmerge | Abacus1234 | Mail Merge | 10 | 10-14-2013 06:37 AM |
MailMerge - Time showing 12:30 instead of 0:30 | Chris424 | Mail Merge | 2 | 11-17-2011 05:51 AM |