Date problem in Mail Merge

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. Strange problem with long date format not transferring
to a MailMerge document. I have used the Date:() function
in a query and set Format to long date (ie 03 September
2003). This works when I run the query but when I open a
Merge doc on this query and select the Date Merge field it
comes out in short format (ie 03/09/03). I have set the
format in word to long date and thats what appears when I
insert date using Word, so why is the format changing from
the Query to Word? Thanks, Noel
 
Noel:

Try right-clicking on the mail merge code in Word and see if you can't edit
the code to get what you what.

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)
 
The Format setting doesn't get transferred to Word.

Use the Format() function instead. In your Query, create a Calculated
Column:

FDate: Format(Date(), "dd MMMM yyyy")

and use this Column in Word.
 
Back
Top