A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mailmerge from Access using date fields



 
 
Thread Tools Display Modes
  #1  
Old February 15th 10, 02:19 PM posted to microsoft.public.word.mailmerge.fields
Sue
external usenet poster
 
Posts: 132
Default Mailmerge from Access using date fields

Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on the
DB to medium date. (12-Sep-61) but still back to front. Can someone advise
me? PLEASE!! Many thanks..... Sue
Ads
  #2  
Old February 15th 10, 02:47 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 19,312
Default Mailmerge from Access using date fields

Format the mergefield with a date formatting switch \@ "d MMM yyyy" -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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



"Sue" wrote in message
...
Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro
back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on
the
DB to medium date. (12-Sep-61) but still back to front. Can someone
advise
me? PLEASE!! Many thanks..... Sue



  #3  
Old February 15th 10, 09:25 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default Mailmerge from Access using date fields

In addition to the method that Graham has suggested, you can also use the
Format() function in a query in Access to force the date into the required
format.

Format([Datefield], "d mmm yy")

will convert the contents of the date field to text in the format 12 Sep 61.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Sue" wrote in message
...
Hi got a simple Access database for client details. One field is date of
birth. When merging it into letters etc, the date of birth comes thro
back
to front. For example, 12 Sept 61, comes thro as 9/12/61, which is the
american way around but can be confusing here. I changed the format on
the
DB to medium date. (12-Sep-61) but still back to front. Can someone
advise
me? PLEASE!! Many thanks..... Sue


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge from Access - incorrect date/time format dawnjlane Mailmerge 3 August 3rd 08 12:56 PM
Order of data fields in mailmerge from access table Hannah Mailmerge 1 March 9th 08 07:42 AM
Access Query to mailmerge US Date Big Mac Mailmerge 5 January 2nd 08 06:01 PM
How to use access query computed fields in Word mailmerge Rey Mailmerge 5 June 23rd 05 06:26 PM
empty date fields in access Alan Mailmerge 4 January 13th 05 12:57 AM


All times are GMT +1. The time now is 08:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.