Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date problem with mail merge Word 2002
I have a table of data in Access 2002 which is used as the source table for
a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which fall between 1stday/anymonth/any year and 12thday/anymonth/any year are rearranged in the wrong format. For example 4th July 2005 from the database would be displayed as 07/05/2005 in the merged document. In addition blank date fields from the source table are shown as the current date for that particular day. This strange anomaly does not occur for any dates where the day goes beyond 12!? However, when I run the same document and source on my own PC using Word 2003 the dates in the merged document are shown correctly and in the correct format and blank date data is not shown. As a stab in the dark I'm using Microsoft Word 11.0 Object library as the reference setting. Should this be changed for Word 2002 to a lower reference? Or could there be a bug in Word 2002? Any help or feedback would be much appreciated. At present my client would have to check the document for all those dates 12th/month and edit them. Obviously not very efficient. Many thanks in advance |
#2
|
|||
|
|||
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Andy Davis" wrote in message ... I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which fall between 1stday/anymonth/any year and 12thday/anymonth/any year are rearranged in the wrong format. For example 4th July 2005 from the database would be displayed as 07/05/2005 in the merged document. In addition blank date fields from the source table are shown as the current date for that particular day. This strange anomaly does not occur for any dates where the day goes beyond 12!? However, when I run the same document and source on my own PC using Word 2003 the dates in the merged document are shown correctly and in the correct format and blank date data is not shown. As a stab in the dark I'm using Microsoft Word 11.0 Object library as the reference setting. Should this be changed for Word 2002 to a lower reference? Or could there be a bug in Word 2002? Any help or feedback would be much appreciated. At present my client would have to check the document for all those dates 12th/month and edit them. Obviously not very efficient. Many thanks in advance |
#3
|
|||
|
|||
There's a knowledgebase article on this subject at
http://support.microsoft.com/default...b;en-us;327579 I notice that this article was updated a few months ago to say the problem has been fixed in Word/Office XP service pack 3. Previously you had to get a hotfix from MS Support, or modify the way that you were transferring data between Access and Word (i.e. you could use a different connection method, or you could for example use an Access query to reformat the date as a text string). Peter Jamieson "Andy Davis" wrote in message ... I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which fall between 1stday/anymonth/any year and 12thday/anymonth/any year are rearranged in the wrong format. For example 4th July 2005 from the database would be displayed as 07/05/2005 in the merged document. In addition blank date fields from the source table are shown as the current date for that particular day. This strange anomaly does not occur for any dates where the day goes beyond 12!? However, when I run the same document and source on my own PC using Word 2003 the dates in the merged document are shown correctly and in the correct format and blank date data is not shown. As a stab in the dark I'm using Microsoft Word 11.0 Object library as the reference setting. Should this be changed for Word 2002 to a lower reference? Or could there be a bug in Word 2002? Any help or feedback would be much appreciated. At present my client would have to check the document for all those dates 12th/month and edit them. Obviously not very efficient. Many thanks in advance |
#4
|
|||
|
|||
To all
Many, many thanks for the advice. At least I now know it wasn't me going mad seeing the date reversed! Dawn "Peter Jamieson" wrote in message ... There's a knowledgebase article on this subject at http://support.microsoft.com/default...b;en-us;327579 I notice that this article was updated a few months ago to say the problem has been fixed in Word/Office XP service pack 3. Previously you had to get a hotfix from MS Support, or modify the way that you were transferring data between Access and Word (i.e. you could use a different connection method, or you could for example use an Access query to reformat the date as a text string). Peter Jamieson "Andy Davis" wrote in message ... I have a table of data in Access 2002 which is used as the source table for a mail merge document using Word 2002 on my clients PC. The data is transferred OK but I've noticed that any dates which fall between 1stday/anymonth/any year and 12thday/anymonth/any year are rearranged in the wrong format. For example 4th July 2005 from the database would be displayed as 07/05/2005 in the merged document. In addition blank date fields from the source table are shown as the current date for that particular day. This strange anomaly does not occur for any dates where the day goes beyond 12!? However, when I run the same document and source on my own PC using Word 2003 the dates in the merged document are shown correctly and in the correct format and blank date data is not shown. As a stab in the dark I'm using Microsoft Word 11.0 Object library as the reference setting. Should this be changed for Word 2002 to a lower reference? Or could there be a bug in Word 2002? Any help or feedback would be much appreciated. At present my client would have to check the document for all those dates 12th/month and edit them. Obviously not very efficient. Many thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2002 and Word 2003 trading default file association | Microsoft Word Help | |||
Problem with automating mail merge | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
255 character limit in Word mail merge | Mailmerge |