Mail merge from Access to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PatAce - 30 Mar 2005 07:13 GMT

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.

Reply to this Message

Graham Mayor - 30 Mar 2005 08:12 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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.

Reply to this Message

Peter Jamieson - 30 Mar 2005 08:18 GMT

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

>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.

Reply to this Message

Graham Mayor - 30 Mar 2005 16:09 GMT

Wouldn't that still be a short format ?;)

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Use a date format switch, e.g. press Alt-F9 in your Word mail merge
> min document and modify e.g.
[quoted text clipped - 12 lines]
>> 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.

Reply to this Message

Peter Jamieson - 30 Mar 2005 18:47 GMT

Yeah :-}

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

would be a better example.

Peter Jamieson

> Wouldn't that still be a short format ?;)
>
[quoted text clipped - 14 lines]
>>> 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.

Reply to this Message

Patrick Foley - 30 Mar 2005 23:03 GMT

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.

> Yeah :-}
>
[quoted text clipped - 22 lines]
> >>> 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.

Reply to this Message