View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Word-Excel mail merge

If you formatted it using a date/time switch in Word, what switch did you
use?

If you formatted it in Excel, do not expect Word to use the formatting you
used - try a date switch in Word, e.g. change

{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"MM DDD YY" }

substituting whatever format you need.

There's an "explanation" of sorts at http://tips.pjmsn.me.uk/t0003.htm

Peter Jamieson

"mark" wrote in message
...
why do I get a time along with the date when I have it formatted to only
show
a date