Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Datefields from Access
Hi,
I am merging with an Access database created from SAS. The date format exported from SAS is dd/mm/yyyy (ddmmyy10. in SAS-code). In Access is's dd-mm-yyyy. But in Word the mergefields comes out as mm/dd/yyyy. What am I doing wrong here? Thnaks. /Sune |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Datefields from Access
You are doing nothing wrong. Word does not interpret any formatting in the
data file. Apply a date switch to the field in the Word document http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sune Fibaek wrote: Hi, I am merging with an Access database created from SAS. The date format exported from SAS is dd/mm/yyyy (ddmmyy10. in SAS-code). In Access is's dd-mm-yyyy. But in Word the mergefields comes out as mm/dd/yyyy. What am I doing wrong here? Thnaks. /Sune |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Datefields from Access
Thank you!
That was very helpful - i also got a few other tings streamlined. /Sune "Graham Mayor" wrote: You are doing nothing wrong. Word does not interpret any formatting in the data file. Apply a date switch to the field in the Word document http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sune Fibaek wrote: Hi, I am merging with an Access database created from SAS. The date format exported from SAS is dd/mm/yyyy (ddmmyy10. in SAS-code). In Access is's dd-mm-yyyy. But in Word the mergefields comes out as mm/dd/yyyy. What am I doing wrong here? Thnaks. /Sune |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Datefields from Access
You are welcome
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sune Fibaek wrote: Thank you! That was very helpful - i also got a few other tings streamlined. /Sune "Graham Mayor" wrote: You are doing nothing wrong. Word does not interpret any formatting in the data file. Apply a date switch to the field in the Word document http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Sune Fibaek wrote: Hi, I am merging with an Access database created from SAS. The date format exported from SAS is dd/mm/yyyy (ddmmyy10. in SAS-code). In Access is's dd-mm-yyyy. But in Word the mergefields comes out as mm/dd/yyyy. What am I doing wrong here? Thnaks. /Sune |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Waiting for Microsoft Access to Accept DDE Commands | Mailmerge | |||
Using Access 97 for Word 2000 Mailmerge | Mailmerge | |||
How do I access Word Help file without having to insert a CD ever. | Microsoft Word Help | |||
Word 97 opening Access 2000 | Mailmerge | |||
Word mail merge with Access | Mailmerge |