I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH

Hmmm. The "simplest" answer would probably be to use a DDE connection to
Excel so that the data comes over the link exactly the way it looks in Excel.
That type of connection won't always work in later software versions, but if
it does for you, then that will be simplest. Activate "Confirm conversions on
open" in Tools/Options/General, then link to the Excel file (again).

Other than that, you could conceivably do this using some fancy footwork in
the Mergefield codes. Word doesn't provide any formatting switch for
displaying a date with "st". But it does provide switches that will change
plain ordinals into cardinals. However, you may not be able to achieve the
superscript.

{ MERGEFIELD "BirthDate" \@ "d" \* Ordinal } { MERGEFIELD "BirthDate" \@
"MMMM" }

Alt+F9 to toggle the field codes on/off.

-- Cindy

"CWH" wrote:

I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH

Cindy,

Thanks for the reply. Both options did not work.
--
CWH


"Cindy Meister" wrote:

Hmmm. The "simplest" answer would probably be to use a DDE connection to
Excel so that the data comes over the link exactly the way it looks in Excel.
That type of connection won't always work in later software versions, but if
it does for you, then that will be simplest. Activate "Confirm conversions on
open" in Tools/Options/General, then link to the Excel file (again).

Other than that, you could conceivably do this using some fancy footwork in
the Mergefield codes. Word doesn't provide any formatting switch for
displaying a date with "st". But it does provide switches that will change
plain ordinals into cardinals. However, you may not be able to achieve the
superscript.

{ MERGEFIELD "BirthDate" \@ "d" \* Ordinal } { MERGEFIELD "BirthDate" \@
"MMMM" }

Alt+F9 to toggle the field codes on/off.

-- Cindy

"CWH" wrote:

I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH

HOW did they "not work"?

-- Cindy

"CWH" wrote:

Cindy,

Thanks for the reply. Both options did not work.
--
CWH


"Cindy Meister" wrote:

Hmmm. The "simplest" answer would probably be to use a DDE connection to
Excel so that the data comes over the link exactly the way it looks in Excel.
That type of connection won't always work in later software versions, but if
it does for you, then that will be simplest. Activate "Confirm conversions on
open" in Tools/Options/General, then link to the Excel file (again).

Other than that, you could conceivably do this using some fancy footwork in
the Mergefield codes. Word doesn't provide any formatting switch for
displaying a date with "st". But it does provide switches that will change
plain ordinals into cardinals. However, you may not be able to achieve the
superscript.

{ MERGEFIELD "BirthDate" \@ "d" \* Ordinal } { MERGEFIELD "BirthDate" \@
"MMMM" }

Alt+F9 to toggle the field codes on/off.

-- Cindy

"CWH" wrote:

I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH

Cindy,

They did not put the "st" into superscript.
--
CWH


"Cindy Meister" wrote:

HOW did they "not work"?

-- Cindy

"CWH" wrote:

Cindy,

Thanks for the reply. Both options did not work.
--
CWH


"Cindy Meister" wrote:

Hmmm. The "simplest" answer would probably be to use a DDE connection to
Excel so that the data comes over the link exactly the way it looks in Excel.
That type of connection won't always work in later software versions, but if
it does for you, then that will be simplest. Activate "Confirm conversions on
open" in Tools/Options/General, then link to the Excel file (again).

Other than that, you could conceivably do this using some fancy footwork in
the Mergefield codes. Word doesn't provide any formatting switch for
displaying a date with "st". But it does provide switches that will change
plain ordinals into cardinals. However, you may not be able to achieve the
superscript.

{ MERGEFIELD "BirthDate" \@ "d" \* Ordinal } { MERGEFIELD "BirthDate" \@
"MMMM" }

Alt+F9 to toggle the field codes on/off.

-- Cindy

"CWH" wrote:

I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH

As I wrote in my original reply, I doubt that you're going to find anything
that will do that.

If you really need the superscript, then you're probably going to have to
run a maco over the mail merge result...

-- Cindy

"CWH" wrote:

Cindy,

They did not put the "st" into superscript.
--
CWH


"Cindy Meister" wrote:

HOW did they "not work"?

-- Cindy

"CWH" wrote:

Cindy,

Thanks for the reply. Both options did not work.
--
CWH


"Cindy Meister" wrote:

Hmmm. The "simplest" answer would probably be to use a DDE connection to
Excel so that the data comes over the link exactly the way it looks in Excel.
That type of connection won't always work in later software versions, but if
it does for you, then that will be simplest. Activate "Confirm conversions on
open" in Tools/Options/General, then link to the Excel file (again).

Other than that, you could conceivably do this using some fancy footwork in
the Mergefield codes. Word doesn't provide any formatting switch for
displaying a date with "st". But it does provide switches that will change
plain ordinals into cardinals. However, you may not be able to achieve the
superscript.

{ MERGEFIELD "BirthDate" \@ "d" \* Ordinal } { MERGEFIELD "BirthDate" \@
"MMMM" }

Alt+F9 to toggle the field codes on/off.

-- Cindy

"CWH" wrote:

I am using Office 2003

When I use an Excel file as my data file, is there any way that I can get
dates to appear as 1st August, with the "st" in superscript. It is in that
format in Excel but when I mailmerger the data the format is lost. Is there
some way to format that field in Word?
--
CWH