Mailmerge merged field format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Liz T NN14 - 18 Nov 2006 10:32 GMT

My source data is in excel and the date field is written - 01 December 2006,
English format. When I use this field in my word document the date is
written - 12/01/2006, American format. How can I change the merged field to
show the English format as written above?

Reply to this Message

Doug Robbins - Word MVP - 18 Nov 2006 15:55 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Also see "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> My source data is in excel and the date field is written - 01 December
> 2006,
> English format. When I use this field in my word document the date is
> written - 12/01/2006, American format. How can I change the merged field
> to
> show the English format as written above?

Reply to this Message

Liz T NN14 - 19 Nov 2006 09:35 GMT

Thanks Doug. The gmayor.com link contained all the information I needed.

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 13 lines]
> > to
> > show the English format as written above?

Reply to this Message