How can I maintain Excel date formats in a mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MKLeisure - 30 Aug 2005 19:18 GMT

I have an Excel spreadsheet with the date column formatted to display the
dates in character format (March 27,2005). When I do the mail merge with a
Word document the date reverts to the fomat it was enterd in 03/27/2005. How
can I get it the maintain the character format in the letter? Additionally
this information is imported into the Excel spreadsheet from a database.

Thanks

Reply to this Message

Doug Robbins - 30 Aug 2005 20:09 GMT

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

>I have an Excel spreadsheet with the date column formatted to display the
> dates in character format (March 27,2005). When I do the mail merge with a
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Rate this thread: