Word 2003 not picking up fields in Access 2002

[George]

Hi everyone. I hope someone can help me

I have an Access 2002 database. It contains various fields that I use to populate documents I have created in Word 2002. I use the mail merge function in Word to do this.

The Access 2002 database and the Word 2002 documents are now in a shared folder that can be accessed by another computer I have recently networked. The new computer runs Word 2003 and Access 2003 (the old one runs Word 2002 and Access 2002)

The problem is that when I use the new 2003 computer and try to merge the documents, some of the fields in the letters become populated by the data in the database and others don't.

I have tried when in Word 2003 to delete the fields from my Word 2002 documents and reinsert them and I have found that in some cases, Word 2003 will put in an extra letter in the field name. When I run the mail merge, it will then insert the data from the Access database so everything is ok. However, if I then use the other 2002 computer to run the same merge, it will not recognise the new field presumably because of that extra letter

Does anyone know how to fix this? I assume it might be an incompatability between how Word 2002 and Word 2003 deal with mail merges. Anyone able to help

Thank
Georg
george61967(DELETE THIS)@yahoo.com.au

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Geprge,

I find that to be highly unusual. Can you send me both the Word2002 and
Word2003 mailmerge main documents so that I can have a look at them. Can
you also open the Access datasource in Access and then click on File Send
To, selecting Microsoft Excel as the format, and send it to me.

In the subject line of the email messages, please insert the following (use
copy and paste)

FEAC4332-369D-4D33-A5F4-B1B6E3587F94

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP