 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2003date formatting
I am not able to get date formatting to work in an Office 2003 mail merge document. I am using the following form of switch: { MERGEFIELD RentalDate \@ "MMMM d, yyyy" } I have tried every combination of adding the switch to the mail merge field....what am I doing wrong? HELP! Hi Joe, > I am not able to get date formatting to work in an Office > 2003 mail merge document. I am using the following form > of switch: { MERGEFIELD RentalDate \@ "MMMM d, yyyy" } > I have tried every combination of adding the switch to > the mail merge field....what am I doing wrong? OK, Word 2003... What's the data source? How does the mergefield data appear with NO switch? And what do you see with the switch? After adding the switch have you explicitly forced the field to update its display (click in it and press F9)? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.mvps.org/word This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Take a look at the thread with a subject "Date format" started on 12/2. Cindy Meister posted the following suggestion which works fine: { Quote "{ = { Mergefield Date } \# "0000'-'00'-'00" }" \@ "MMMM d, yyyy" } The source date is formatted yyyyMMdd.  SignatureCharles Kenyon Word New User FAQ & Web Directory: <URL: http://addbalance.com/word/index.htm> Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) <URL: http://addbalance.com/usersguide/index.htm> See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > I am not able to get date formatting to work in an Office > 2003 mail merge document. I am using the following form > of switch: { MERGEFIELD RentalDate \@ "MMMM d, yyyy" } > I have tried every combination of adding the switch to > the mail merge field....what am I doing wrong? HELP! |
Reply to this Message |
 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.