Date fields are merged incorrectly when I use an Excel data source Jemdlee 5/29/2007 11:43:04 AM I have date fields formatted in the Australian format - dd/mm/yy, but when I merge them into Word, they appear as mm/dd/yy. The field I have in my Word document is "<<Date_1>>" What do I type in to make the format come out the way I want it?

Re: Date fields are merged incorrectly when I use an Excel data source "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/29/2007 1:31:32 PM See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindymeister/MergFram.htm -- 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 "Jemdlee" <Jemdlee[ at ]discussions.microsoft.com> wrote in message news:5213393D-95AF-4A06-A8C3-CD7EA9298953[ at ]microsoft.com... [Quoted Text] >I have date fields formatted in the Australian format - dd/mm/yy, but when >I > merge them into Word, they appear as mm/dd/yy. > The field I have in my Word document is "<<Date_1>>" > What do I type in to make the format come out the way I want it?

Re: Date fields are merged incorrectly when I use an Excel data so Jemdlee 5/30/2007 8:38:05 AM Sorry, that didn't work, or I'm confused. The example says: { Mergefield Date \[ at ] "dd-MMM-yyyy"} - so I would understand that I would need to substitute "Mergefield" with my merge field (that which is highlighted in gray) - which is "<<Date_1>>" - I tried that and it didn't work. Can you please show me the finished product of what it should look like with my merge field, not just an example? I then might be able to grasp understanding of this. Thanks, "Doug Robbins - Word MVP" wrote: [Quoted Text] > See the "Dates: day/month reversed" item under the "Connection methods" > topic of the "Mail merge in Word 2002" section of fellow MVP Cindy > Meister's website at: > > http://homepage.swissonline.ch/cindymeister/MergFram.htm > > > -- > 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 > > "Jemdlee" <Jemdlee[ at ]discussions.microsoft.com> wrote in message > news:5213393D-95AF-4A06-A8C3-CD7EA9298953[ at ]microsoft.com... > >I have date fields formatted in the Australian format - dd/mm/yy, but when > >I > > merge them into Word, they appear as mm/dd/yy. > > The field I have in my Word document is "<<Date_1>>" > > What do I type in to make the format come out the way I want it? > > >

Re: Date fields are merged incorrectly when I use an Excel data so "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/30/2007 9:45:22 AM You're confused! You do one or the other, not both either enter the field manually using CTRL+F9 for the field boundaries or toggle the inserted field (ALT+F9) and modify that. The finished result would be { Mergefield Date_1 \[ at ] "dd-MMM-yyyy"} See if http://www.gmayor.com/formatting_word_fields.htm helps -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Jemdlee wrote: [Quoted Text] > Sorry, that didn't work, or I'm confused. > The example says: > { Mergefield Date \[ at ] "dd-MMM-yyyy"} - so I would understand that I > would need to substitute "Mergefield" with my merge field (that which > is highlighted in gray) - which is "<<Date_1>>" - I tried that and it > didn't work. > Can you please show me the finished product of what it should look > like with my merge field, not just an example? I then might be able > to grasp understanding of this. > > Thanks, > > "Doug Robbins - Word MVP" wrote: > >> See the "Dates: day/month reversed" item under the "Connection >> methods" topic of the "Mail merge in Word 2002" section of fellow >> MVP Cindy Meister's website at: >> >> http://homepage.swissonline.ch/cindymeister/MergFram.htm >> >> >> -- >> 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 >> >> "Jemdlee" <Jemdlee[ at ]discussions.microsoft.com> wrote in message >> news:5213393D-95AF-4A06-A8C3-CD7EA9298953[ at ]microsoft.com... >>> I have date fields formatted in the Australian format - dd/mm/yy, >>> but when I >>> merge them into Word, they appear as mm/dd/yy. >>> The field I have in my Word document is "<<Date_1>>" >>> What do I type in to make the format come out the way I want it?

Re: Date fields are merged incorrectly when I use an Excel data so Jemdlee 5/30/2007 11:56:01 AM Thanks heaps guys! Through your efforts in helping me, you have played a valuable role in affecting the lives of hundreds of kids for the better. God bless heaps, Jem "Graham Mayor" wrote: [Quoted Text] > You're confused! > You do one or the other, not both > either enter the field manually using CTRL+F9 for the field boundaries > or toggle the inserted field (ALT+F9) and modify that. > > The finished result would be > { Mergefield Date_1 \[ at ] "dd-MMM-yyyy"} > > See if http://www.gmayor.com/formatting_word_fields.htm helps > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Jemdlee wrote: > > Sorry, that didn't work, or I'm confused. > > The example says: > > { Mergefield Date \[ at ] "dd-MMM-yyyy"} - so I would understand that I > > would need to substitute "Mergefield" with my merge field (that which > > is highlighted in gray) - which is "<<Date_1>>" - I tried that and it > > didn't work. > > Can you please show me the finished product of what it should look > > like with my merge field, not just an example? I then might be able > > to grasp understanding of this. > > > > Thanks, > > > > "Doug Robbins - Word MVP" wrote: > > > >> See the "Dates: day/month reversed" item under the "Connection > >> methods" topic of the "Mail merge in Word 2002" section of fellow > >> MVP Cindy Meister's website at: > >> > >> http://homepage.swissonline.ch/cindymeister/MergFram.htm > >> > >> > >> -- > >> 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 > >> > >> "Jemdlee" <Jemdlee[ at ]discussions.microsoft.com> wrote in message > >> news:5213393D-95AF-4A06-A8C3-CD7EA9298953[ at ]microsoft.com... > >>> I have date fields formatted in the Australian format - dd/mm/yy, > >>> but when I > >>> merge them into Word, they appear as mm/dd/yy. > >>> The field I have in my Word document is "<<Date_1>>" > >>> What do I type in to make the format come out the way I want it? > > >