Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 162
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
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft