Mail Merge Problem

[FLYNNE]

Mail Merge problem
The Excel data file contains two columns labelled as Day and Date
respectively.

The Date column contains sequential dates in the format " 26th September
2008".
The main word document contains the <<Day>> and <<Date>> mergefields.

However when the word document is merged with data file the date is
displayed as 26/09/2008 and not as 26th September 2008.

The day is displayed correctly.

How do I rectify this problem ?
__________________

 

[smartgal]

One rather tedious fix would be to have the date on your data be a number of
separate fields, then you'd could just merge all the fields. For instance,
I'd have fields for date, suffix, month and year. For date obviously you
just have the numeric date (26, 27, 28). For suffix you will have to
identify what the suffix it for each date (23 would be "rd" versus 25 and
"th"). Your month and year are clear. When done, if the date *must* display
as "26th September 2008" then you're all set.

Good luck.

 

[David McRitchie]

Assuming that the purpose of the spreadsheet is simply to feed
the Word Document, and the Excel worksheet is displaying the
a numeric value with a date format. Use =TEXT(C1,"dd mmmm yyyy")
and include the new cell instead of the old one.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

I don't see how you had 26th September 2008
and not 26 September 2008 as Excel would not
treat the one with 26th as a number. If that is what
you had then it was text and MS Word is converting it, and you
would have to correct the problem on the MS Word side..

 

[Bruce Sinclair]

Mail Merge problem
The Excel data file contains two columns labelled as Day and Date
respectively.

The Date column contains sequential dates in the format " 26th September
2008".
The main word document contains the <<Day>> and <<Date>> mergefields.

However when the word document is merged with data file the date is
displayed as 26/09/2008 and not as 26th September 2008.

The day is displayed correctly.

How do I rectify this problem ?

Sounds like you need to link to the XL data using DDE and not one of the
other methods available. That solved a heap of format problems I had.