Mail Merge Field Formatting

[Janet]

I've created a mail merge document using Word XP and an
Excel spreadsheet. One of the fields is a date field. In
the spreadsheet this field is formatted at March 14,
2001. When it is merged to the Word document, the date is
displayed at 03/14/2001. Is there any way to retain the
formatting from the spreadsheet into the word document?

Any and all help greatly appreciated!

 

[Doug Robbins]

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

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

You may also need to 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
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Janet]

Your help is much appreciated. This works great!

-----Original Message-----
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

You may also need to 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
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP



.