Date & Text Mergefield

A

Andy Roberts

I have an excel spreadsheet with a column which contains dates. However
some of those dates aren't required sometimes and in these cases the text
string "ASAP" is added instead of a date.

In my word doc I have a merge field which reads...

{MERGEFIELD Date_Required\ @DD/MM/YY}

This returns the dates fine, however where I have ASAP in the spreadsheet
this comes out as the current date (ie Today) instead of ASAP. How can I
get the mergefield to display the date correctly when one has been entered
in the spreadsheet but also display the ASAP text string when this has been
entered instead of a date?

Andy
Office 2010
Win XP Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
Date Formats 4
Display weeks from a Milestone 0
Creating a Search using a combo box and then creating a report. 4
Autofill Date in Word 15.33 for Mac 0
Formatting question: how to format duration (time spent)? 0
Wod Mail Merge Date Format 0

Top