MergeField multiple conditions (format date and delete previous text if blank)

		Microsoft Office Forums > Microsoft Word > Mail Merge
MergeField multiple conditions (format date and delete previous text if blank)

FAQ

Thread Tools

Display Modes

Alex1s85 MergeField multiple... 07-27-2020, 02:22 PM

Charles Kenyon I moved this to the mailmerge... 07-27-2020, 03:56 PM

macropod Not so - it can insert... 07-28-2020, 01:02 AM

Alex1s85 I want to modify some... 07-28-2020, 05:43 AM

Charles Kenyon What I provided does what you... 07-28-2020, 09:36 AM

Alex1s85 You have right. I didn't... 07-28-2020, 12:30 PM

Charles Kenyon You are welcome. Few have... 07-29-2020, 03:10 PM

07-28-2020, 05:43 AM

Alex1s85

Windows 10 MergeField multiple conditions (format date and delete previous text if blank)

Office 2016

Advanced Beginner

Join Date: Oct 2019

Location: Thessaloniki, Greece

Posts: 30

I want to modify some templates which produce documents in live production.

Data comes from the core operational system - so to change the format in this data its not an option.

My data contains dates in format yyyy-dd-mm.

I have to merge dates in the format dd-mm-yyyy with the prefix "Date: " and to hide the mergefield in case that the date is not available.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete comma and space after blank merged value. Also remove Previous space and word before blank	Alex1s85	Mail Merge	4	01-18-2020 11:30 PM
Highlight Blank Cell Based on Multiple Conditions from Other Cells in Row	PrincessApril	Excel	3	11-21-2019 12:50 PM
from text to table, with conditions depending on format	Marco	Word VBA	2	10-29-2015 06:40 PM
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 PM.