How do I get a Word mail merge to keep my access date format? JBM 12/8/2008 4:31:00 AM I am using Office 2007 (trying to use mail merge to merge Access data in Word so I can control formatting). Word changes the date format from yyyy-MM-dd to MM/dd/yyyy. A previous post (for office 2003) suggested using a switch, but when I do that, Word reports that the field does not exist in the source. My mergefields are encased in pointed brackets rather than braces.

Re: How do I get a Word mail merge to keep my access date format? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/8/2008 6:58:31 AM Use Alt+F9 to toggle on the display of the field codes and then add the formatting switch inside the closing }. -- 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 "JBM" <JBM[ at ]discussions.microsoft.com> wrote in message news:AA5220F7-C626-4C8B-A143-61EE0E65A945[ at ]microsoft.com... [Quoted Text] >I am using Office 2007 (trying to use mail merge to merge Access data in >Word > so I can control formatting). Word changes the date format from yyyy-MM-dd > to > MM/dd/yyyy. A previous post (for office 2003) suggested using a switch, > but > when I do that, Word reports that the field does not exist in the source. > My > mergefields are encased in pointed brackets rather than braces.