Importing date field from Access into Word

[jh3016]

I want to import date fields for a mailmerge letter. However when I import the date fields, they appear "06/24/2003". I want it to appear "June 24, 2003". Is there a simple way to do this?

I have the table and form formatted as mmmm dd", " yyyy.

Thanks in advance.

 

[BSando]

Save the table field as a string and not a date.

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[jh3016]

Sorry, I am not that good with Access. What do you mean by saving as a string?

 

[vree]

I believe sando is suggesting that at the table level, your field is of Date/Time type. Is that correct? IF so, the suggestion is that you change the field type to text. I believe in a mail merge, Word imports text "As is". However, if you choose not to change your field type in your db, investigate "Field codes" in Word. I use them all the time, and they are pretty powerful.

For example, I have a curreny field in Access, Dues ($52,455) which imported into Word shows up like (52455). Prior to the merge, right click on the field in question, and choose field codes.
To clean up the example I gave you

1. Right Click on “Dues” Field.
2. Click “Toggle Field Code”
3. You will then see: {MERGEFIELD Dues}
4. Insert \# $#,##0.00 at the end of the merge field.
{MERGEFIELD Dues\# $#,##0.00}

5. Right Click "Toggle Field Code" to return.

After Mail merge, your field will be $52, 455.

With a little experimentation, you can to alot! Good luck.

vree

http://www.groundworkssoftware.com