Access feds data to Ms Word

[mrchonginhk]

Suppose I have a query outputing only one single record of only one field, eg "Peter".
I want it to show on Ms Word. If database query change later to "Mary", I want the Peter on Ms Word becomes Mary too.

I created a field code on Ms Word like this

{DDEAUTO MSAccess "C:\\File1.mdb;Table Table1" All \t}

It works. However, it also shows the header of the Access Table like this in Ms Word now:-

Name
Peter

What can I do to to remove the header 'Name' ?
Thanks

 

[jasmith4]

Why not use Access's Merge-with-Word rather than Word's DDEAUTO field? When you do that, you'd use a merge field in Word instead, and the Access table's field name ("Name") becomes the parameter of that merge field, so all you get is Peter/Mary.

In Access <= 2003 you'd select the table in the database window's Tables, then pull down Tools / Office Links / Merge with Word. In Access >= 2007 you'd go to the External Data ribbon and click the Word Merge button. Either way you'll get a wizard which will allow you to use an existing Word document.