Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge date from Excel 2003 to Word 2003 in same format
When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003
document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009 merges as 03-18-2009. Both the Excel and Word programs have their language set at English (Australia), although the Word Language box has both English (Australia) and English (US) listed, with English (Australia) set as the default. Does anyone have any ideas on how I can get the date to show in the correct format, dd-mm-yyyy? Cheers. Travers |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge date from Excel 2003 to Word 2003 in same format
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" 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 "TP" (donotspam) wrote in message news When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003 document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009 merges as 03-18-2009. Both the Excel and Word programs have their language set at English (Australia), although the Word Language box has both English (Australia) and English (US) listed, with English (Australia) set as the default. Does anyone have any ideas on how I can get the date to show in the correct format, dd-mm-yyyy? Cheers. Travers |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge date from Excel 2003 to Word 2003 in same format
Thanks Doug. i had a look at the information on the website that you
directed me to. Unfortunately, it meant nothing to me. I was hoping for a simple solution! I thought that if I could delete the English (US) from the language box, leaving only English (Australia) it may help. But I don't know how to do that. I have performed the same mail merge in the past without this problem, so I don't know why it's appearing now. Maybe, I'll have to type the dates (in Excel) in text format! Cheers. Travers "Doug Robbins - Word MVP" wrote: See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002/2003" 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 "TP" (donotspam) wrote in message news When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003 document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009 merges as 03-18-2009. Both the Excel and Word programs have their language set at English (Australia), although the Word Language box has both English (Australia) and English (US) listed, with English (Australia) set as the default. Does anyone have any ideas on how I can get the date to show in the correct format, dd-mm-yyyy? Cheers. Travers |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge date from Excel 2003 to Word 2003 in same format
Hi. I checked through a few other posts, on this site and found the solution
at: http://www.gmayor.com/mail_merge_lab...th_word_xp.htm In MS Word 2003 change one of the Word options settings i.e. Tools Options General Confirm conversion on open. (tick the "Confirm conversion on open" box). When you select the data source, when connecting to an Excel data file, a "Confirm Data Source box appears, from which you should select DDE, whereupon the the date will be merged in its correct format. Worked for me. Travers "TP" wrote: Thanks Doug. i had a look at the information on the website that you directed me to. Unfortunately, it meant nothing to me. I was hoping for a simple solution! I thought that if I could delete the English (US) from the language box, leaving only English (Australia) it may help. But I don't know how to do that. I have performed the same mail merge in the past without this problem, so I don't know why it's appearing now. Maybe, I'll have to type the dates (in Excel) in text format! Cheers. Travers "Doug Robbins - Word MVP" wrote: See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002/2003" 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 "TP" (donotspam) wrote in message news When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003 document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009 merges as 03-18-2009. Both the Excel and Word programs have their language set at English (Australia), although the Word Language box has both English (Australia) and English (US) listed, with English (Australia) set as the default. Does anyone have any ideas on how I can get the date to show in the correct format, dd-mm-yyyy? Cheers. Travers |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge date from Excel 2003 to Word 2003 in same format
Which is the same information as provided in the link to which I directed
you. -- 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 "TP" (donotspam) wrote in message ... Hi. I checked through a few other posts, on this site and found the solution at: http://www.gmayor.com/mail_merge_lab...th_word_xp.htm In MS Word 2003 change one of the Word options settings i.e. Tools Options General Confirm conversion on open. (tick the "Confirm conversion on open" box). When you select the data source, when connecting to an Excel data file, a "Confirm Data Source box appears, from which you should select DDE, whereupon the the date will be merged in its correct format. Worked for me. Travers "TP" wrote: Thanks Doug. i had a look at the information on the website that you directed me to. Unfortunately, it meant nothing to me. I was hoping for a simple solution! I thought that if I could delete the English (US) from the language box, leaving only English (Australia) it may help. But I don't know how to do that. I have performed the same mail merge in the past without this problem, so I don't know why it's appearing now. Maybe, I'll have to type the dates (in Excel) in text format! Cheers. Travers "Doug Robbins - Word MVP" wrote: See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002/2003" 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 "TP" (donotspam) wrote in message news When I mail merge a date from an Excel 2003 spreadsheet to a MS Word 2003 document, it switches from dd-mm-yyyy to mm-dd-yyyy format. eg 18-03-2009 merges as 03-18-2009. Both the Excel and Word programs have their language set at English (Australia), although the Word Language box has both English (Australia) and English (US) listed, with English (Australia) set as the default. Does anyone have any ideas on how I can get the date to show in the correct format, dd-mm-yyyy? Cheers. Travers |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge #'s from Excel 2003 to Word 2003 in correct format? | Mailmerge | |||
Word 2003 Mail Merge cannot open Excel 2003 document | Microsoft Word Help | |||
Date format in Word 2003 mailmerging from excel file. | Mailmerge | |||
Bug in Word 2003 (mail merge & date format)? | Mailmerge | |||
Mail Merge date format problem with Word 2003 | New Users |