Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2014, 08:53 AM
NikkiR NikkiR is offline Adding text before a date merge field AND fomatting date as well Windows 7 64bit Adding text before a date merge field AND fomatting date as well Office 2010 64bit
Novice
Adding text before a date merge field AND fomatting date as well
 
Join Date: Aug 2014
Posts: 1
NikkiR is on a distinguished road
Default Adding text before a date merge field AND fomatting date as well

I'm new to the advanced features of mail merging and I'm trying to add text before a merge field (which is a date) and format the field as well.



Originally I was just formatting the date so added \@ "dd/MM/yyyy" to the code and it worked...

Then I learnt about adding text before and after merge fields and so added \b "Date of Event : " to the code and it will still format the field but will not add the text.

Any advice on what I'm doing wrong? Is it actually possible to do this?

Thanks in advance
Reply With Quote
  #2  
Old 08-06-2014, 07:18 PM
macropod's Avatar
macropod macropod is offline Adding text before a date merge field AND fomatting date as well Windows 7 32bit Adding text before a date merge field AND fomatting date as well Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The \b and \f switches don't work well with other switches, so any conditional text will have to be incorporated into a separate IF field (or you could put the lot into a single IF field). For example:
{IF{MERGEFIELD Event}<> "" "Date of Event : {MERGEFIELD Event \@ "dd/MM/yyyy"}"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
Adding text before a date merge field AND fomatting date as well Date Field to add 10 Days to Current Date Erbwon Word 6 11-12-2012 06:17 PM
Adding text before a date merge field AND fomatting date as well Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 AM.


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