| 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 | |||
Linear Mode
