Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2004

Tip: Looking for answers? Try searching our database.

Merging null date field from Excel results in today's date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cheryl - 18 Mar 2004 02:48 GMT
In my document, I am attempting to merge in several date
fields that do not always contain data. I am finding that
when the datasource (Excel format) field is null, today's
date merges into the document. No amount of manipulation
of IF fields has given me the result I need. I need it to
remain blank if there is no date entered into the original
source. I don't know if this matters, but the Excel
datasource is overwritten on a monthly basis from another
software program export, so changing the formatting or
subsituting something in the Excel spreadsheet for the
blank fields will not work. The data will change too
frequently and it will become prohibitive.

Thanks for any help you can give me.

Oh, and did I mention that tomorrow is my last day on this
job and I really need to have this done before I go?
macropod - 18 Mar 2004 12:02 GMT
Hi Cheryl,

Ordinarily, something like this should work:
{IF{MERGEFIELD MERGEDATE}="" "" {MERGEFIELD MERGEDATE \@ "d MMM yyyy"}}

Also, provided your problem merge data never incorporates today's date, an
IF test like the following might work:
{IF{MERGEFIELD MERGEDATE \@ yyyyMMdd}={DATE \@ yyyyMMdd} "" {MERGEFIELD
MERGEDATE \@ "d MMM yyyy"}}

Cheers

> In my document, I am attempting to merge in several date
> fields that do not always contain data. I am finding that
[quoted text clipped - 13 lines]
> Oh, and did I mention that tomorrow is my last day on this
> job and I really need to have this done before I go?
Cheryl - 18 Mar 2004 15:18 GMT
Unfortunately, neither of those tips worked. The first one
behaved the same way as everything else I tried, resulting
in today's date. The second method just made all of the
data come out blank.

Thanks for the tips, though!

>-----Original Message-----
>Hi Cheryl,
[quoted text clipped - 33 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.