Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Mail merge date problem

    HI All,

    We're trying to do a mail merge with Word 2002 and Excel 2002. The problem is that if a person has a dirthdate where the day of birth is less than 12, then when the merge happens, the date and month can flip.

    For example, if the person is born August 6 (8/6), the merge document comes out as June 8 (6/8).

    Can any one figure this out? Microsoft com doesn't seem to address this issue.

    Many thanks

    Nigel

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    Pull your mail merge data from a query that has BirthDay: Format(BirthDate,"yyyy/mm/dd") instead of BirthDate. You will have to edit your merge documents to change the name of the field. The problem is with different computers using different regional settings. I use this format all the time and have yet to see Access switch the days and months on me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •