Mail Merge from Access 2003 to Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KarenMike - 15 Feb 2008 19:50 GMT

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?

Signature

Karen K

Reply to this Message

macropod - 16 Feb 2008 02:22 GMT

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

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>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?

Reply to this Message

Wyatte - 02 Apr 2008 16:19 GMT

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.

> 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?

Reply to this Message

Rate this thread: