Microsoft Office Forums Help Formatting Time in A MailMerge Field

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2018, 05:17 PM
JennEx JennEx is offline Help Formatting Time in A MailMerge Field Windows XP Help Formatting Time in A MailMerge Field Office 2013
Competent Performer
Help Formatting Time in A MailMerge Field
 
Join Date: May 2010
Posts: 157
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 Help Formatting Time in A MailMerge Field Windows 7 64bit Help Formatting Time in A MailMerge Field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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 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 Help Formatting Time in A MailMerge Field Windows XP Help Formatting Time in A MailMerge Field Office 2013
Competent Performer
Help Formatting Time in A MailMerge Field
 
Join Date: May 2010
Posts: 157
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 Help Formatting Time in A MailMerge Field Windows 7 64bit Help Formatting Time in A MailMerge Field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,480
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 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 Help Formatting Time in A MailMerge Field Windows XP Help Formatting Time in A MailMerge Field Office 2013
Competent Performer
Help Formatting Time in A MailMerge Field
 
Join Date: May 2010
Posts: 157
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
Help Formatting Time in A MailMerge Field 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
Help Formatting Time in A MailMerge Field Mailmerge printing with field names Jvallee Mail Merge 9 04-16-2014 06:30 PM
Help Formatting Time in A MailMerge Field Yes/No field does not work in mailmerge Abacus1234 Mail Merge 10 10-14-2013 06:37 AM
Help Formatting Time in A MailMerge Field 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 04:41 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft