Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-17-2018, 05:17 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 137
JennEx is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-17-2018, 06:12 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,523
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Do you have anything other than times in that column?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-21-2018, 04:32 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 137
JennEx is on a distinguished road
Default

Hi Paul, thanks for stepping up with assistance.
This issue, as well as the one posted here
http://www.msofficeforums.com/mail-m...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.
Reply With Quote
  #4  
Old 05-21-2018, 04:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,523
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-21-2018, 06:47 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 137
JennEx is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 01:29 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft