Mail Merge Word and Access: Help Changing Dates from US to UK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jen - 12 Mar 2004 14:51 GMT

I have created a table in Access with dates in, which are set up as d-mmm-yy format (UK style)

I am trying to merge the records into labels in Word, but they are coming up in US format, as m/d/yy format. I have tried using different switches to put it right, but it seems to be reading the month as the day and vice versa, so when I use the switches it comes up like 000 4 04 instead of 6-April-2004 and strange things like that

I have looked at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm but can't find a solution

Many thanks :

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 13 Mar 2004 02:22 GMT

See the "Dates: day/month reversed" item under the "Connection Methods"
topic of the "Mail merge in Word 2003" section of fellow MVP CIndy Meister's
website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I have created a table in Access with dates in, which are set up as
>d-mmm-yy format (UK style).
[quoted text clipped - 9 lines]
>
> Many thanks :)

Reply to this Message

sk - 14 Mar 2004 05:08 GMT

You need to use the following format within your document

{ MERGEFIELD \@ "dd/MM/yyy" **** } where ****=the
name of the merged field

In your document (label) press Alt + F9 to toggle to
display the formats

>-----Original Message-----
>I have created a table in Access with dates in, which are set up as d-mmm-yy format (UK style).
>
>I am trying to merge the records into labels in Word, but they are coming up in US format, as m/d/yy format. I

have tried using different switches to put it right, but
it seems to be reading the month as the day and vice
versa, so when I use the switches it comes up like 000 4
04 instead of 6-April-2004 and strange things like that!

>I have looked at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

but can't find a solution!

>Many thanks :)
>
>.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 14 Mar 2004 07:16 GMT

The formatting switch needs to be after the mergefield ****. HOWEVER, in
this case, simply adding a formatting switch to the merge fields will NOT
resolve the problem.

See the link in my response to the OP

Signature

> You need to use the following format within your document
>
[quoted text clipped - 22 lines]
>>
>>.

Reply to this Message

Rate this thread: