Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Dates in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phylby - 17 Dec 2003 20:26 GMT
When merging a document with Excel, the result shows the date value, not the day, Month, day and year as formatted in Excel.  How do I format the word letter to show the words not the value?
Peter Jamieson - 17 Dec 2003 22:45 GMT
Can you be more specific about what you mean by a "date value"?

Two things may help:

In versions of Word after Word 2000, the simplest way to get what you see in
Excel is /usually/ to change the method  Word uses to connect to Excel -
check Word Tools|Options|General|"confirm conversion at open", re-connect to
the date source, and select the DDE option when prompted.

Word lets you put date format "switches" in mergefields, e.g. instead of

{ MERGEFIELD mydate }

you can use

{ MERGEFIELD mydate \@"MMMM DD, YYYY" }

etc. If your date is coming across as anything Word recognises as a date
these switches may help.
--
Peter Jamieson - Word MVP

> When merging a document with Excel, the result shows the date value, not the day, Month, day and year as formatted in Excel.  How do I format the
word letter to show the words not the value?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.