Merge Field w/Date



In Word 2003 when using Mail Merge on a form, one of the merge items is a
date. The data source is an Excel spreadsheet where the cell is formatted as
text and the date manually typed as March 1, 2009 but when it's merged into
the Word form the date comes out as 3/1/2009. Is there a way to change the
date format of that merge field?

Suzanne S. Barnhill

See the Help topic "Date-Time Picture (\@) field switch" for instructions on
how to add the appropriate switch to your mergefield. In this case, you want
\@ MMMM d, yyyy.

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question