[John]

I am using Windows XP SP3 and MS Small Business Exchange Server 2003.

My office recently upgraded to Office 2007 from Office 2000. My issue
regards mailmerge in Word 2007 using Excel 2007 as datasource/OLEDB. I would
prefer to use DDE, but that option did not work well for us.

We currently use many Word docs that have the following merge field code and
formatting:

{MERGEFIELD InjuryDate\@"M/d/yyyy"}{MERGEFIELD Injury_Date_Text}

The corresponding fields in Excel database contain date only, text and date
combined or can be completely blank. If one or the other field is empty and
one has data, I want the field with data to insert that data in the Word doc.
If both fields have data I want both fields to insert that data in Word doc
next to each other. If both fields are blank then Word doc should be blank.
I do not want €œzero€� to insert for any blank fields.

Examples of data in those separate fields are as follows:

Injury Date field:
6-12-09
8/15/08

Injury_Date_Text:

Series
And/or 8/16/03
Every day thereafter until 3/2/2007
Series beginning 10/01 €“ each and every working day thereafter

My problem:
Our merging process was working fine with contents of the above fields
inserting properly into all of our Word docs. However, after a couple of
days various issues began to arise when merging. If the Injury Date field is
blank a zero would print. Sometimes the Injury Date Text field would not
insert its contents into the Word doc. Sometimes, the fields would insert
the contents properly, but it was all random. After reading several posts on
this Discussion Group reformatted all columns containing Date and/or Text
contents via the Data/Text to Columns suggestion. As an aside, we have
several numerical and date columns in the datasource worksheet. All were
randomly working or not working. I reformatted my word mergefields using Mr.
Mayors link to formatting merge fields in Word information. Still we are
experiencing problems. I realize my formatting above does not deal with the
€œzero€� issue. I would like help with that. But, what I do not understand is
why Word randomly chooses to input contents of fields or not.

Please help. Many people access these documents and I need to be secure in
the fact that al the information contained in our database for each
individual records are inserting into our word docs when we merge.

Thank you in advance for any help you can provide.

--
John R.