Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Dates in mailmerge
I am merging an exel file with word 03.
On my previous PC the date formatted in the same form as on excel ie. 19 Feb 08. However in the document it alters to American format 02/19/08 and I REALLY don't want that. Whatever I try to do, the format in the merged letter stays wrong. Can anyone tell me how to fix things. Thanks Nick |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Dates in mailmerge
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org NOTTNICK wrote: I am merging an exel file with word 03. On my previous PC the date formatted in the same form as on excel ie. 19 Feb 08. However in the document it alters to American format 02/19/08 and I REALLY don't want that. Whatever I try to do, the format in the merged letter stays wrong. Can anyone tell me how to fix things. Thanks Nick |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Dates in mailmerge
On 17 Feb, 15:43, "Graham Mayor" wrote:
From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - *Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org NOTTNICK wrote: I am merging an exel file with word 03. On my previous PC the date formatted in the same form as on excel ie. 19 Feb 08. However in the document it alters to American format 02/19/08 *and I REALLY don't want that. Whatever I try to do, the format in the merged letter stays wrong. Can anyone tell me how to fix things. Thanks Nick- Hide quoted text - - Show quoted text - Thanks Graham I tried it but don't get anything different happening. I have checked Excel and the dates are definitely formatted as dates in the format I want in the word document. Any other suggestions. Realise that previously I was using office XP (or whatever the earlier version was). This is now Office 03 - could that be anything to do with it? Nick |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Dates in mailmerge
The other alternative is to add a formatting switch to the mergefield, which
Graham's article at http://www.gmayor.com/formatting_word_fields.htm describes. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "NOTTNICK" wrote in message ... On 17 Feb, 15:43, "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org NOTTNICK wrote: I am merging an exel file with word 03. On my previous PC the date formatted in the same form as on excel ie. 19 Feb 08. However in the document it alters to American format 02/19/08 and I REALLY don't want that. Whatever I try to do, the format in the merged letter stays wrong. Can anyone tell me how to fix things. Thanks Nick- Hide quoted text - - Show quoted text - Thanks Graham I tried it but don't get anything different happening. I have checked Excel and the dates are definitely formatted as dates in the format I want in the word document. Any other suggestions. Realise that previously I was using office XP (or whatever the earlier version was). This is now Office 03 - could that be anything to do with it? Nick |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Dates in mailmerge
I am not sure that will fix it in this instance The Dates Reversed link at
http://homepage.swissonline.ch/cindy...002/MM2002.htm may offer more insights. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Suzanne S. Barnhill wrote: The other alternative is to add a formatting switch to the mergefield, which Graham's article at http://www.gmayor.com/formatting_word_fields.htm describes. "NOTTNICK" wrote in message ... On 17 Feb, 15:43, "Graham Mayor" wrote: From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org NOTTNICK wrote: I am merging an exel file with word 03. On my previous PC the date formatted in the same form as on excel ie. 19 Feb 08. However in the document it alters to American format 02/19/08 and I REALLY don't want that. Whatever I try to do, the format in the merged letter stays wrong. Can anyone tell me how to fix things. Thanks Nick- Hide quoted text - - Show quoted text - Thanks Graham I tried it but don't get anything different happening. I have checked Excel and the dates are definitely formatted as dates in the format I want in the word document. Any other suggestions. Realise that previously I was using office XP (or whatever the earlier version was). This is now Office 03 - could that be anything to do with it? Nick |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statements with dates in mailmerge | Mailmerge | |||
assistnace with mailmerge dates from excel | Mailmerge | |||
Word Mailmerge reading UK dates in Access as US dates | Mailmerge | |||
Mailmerge Dates | Mailmerge | |||
Mailmerge Dates | Mailmerge |