Mail Merge from Access 2003 to Word 2003

[KarenMike]

I am having a problem with the way my dates are showing in word. I have
Access set for mmmm dd", "yyyy, and yet when it merges with Word it is
mm/dd/yyyy. Since the dates are maually entered into Access, rather than use
a dat field in Word, I have used a mergefield.

Any suggestions?

 

[macropod]

Hi Karen,

This can be remedied by adding a suitable formatting switch to your mergefield in Word.

If you select the problem mergefield and press Shift-F9, you'll probably see something like:
{MERGEFIELD MyDate}
Change this to:
{MERGEFIELD MyDate \@ "MMMM DD, YYYY"}
then press F9 to update the field.

Save the document then re-run your mailmerge.

Cheers

 

[Wyatte]

Hi Karen, try reassigning the "feild type" as "Text" instead of "date/time".
This would allow you to enter anything you want into your data-field.