Mail merge from Access to Word

[PatAce]

I use Access to merge with Word and when I merge to word the date comes out
in short format and I want long format. The date is from the table not a
query. The date format in Access is in long format.

 

[Graham Mayor]

Use a date switch on the merge field -
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

Use a date format switch, e.g. press Alt-F9 in your Word mail merge min
document and modify e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

There's a list of the formatting options in Word Help.

Peter Jamieson

 

[Graham Mayor]

Wouldn't that still be a short format ?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

Yeah :-}

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

would be a better example.

Peter Jamieson

 

[Patrick Foley]

Thanks Peter and Graham. I used the word help but couldn't work out the
correct way to add the date. All makes sense now.