![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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] |
![]() |
|
![]() |
||||
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 |
![]() |
Erbwon | Word | 6 | 11-12-2012 06:17 PM |
![]() |
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 |