I've got a Word mailmerge document that uses an Access query as its source

data.  One of the fields on the query shows a list of names.  This field, 

in

the orignal table, is a lookup from another table using an ID code (the

primary key in the lookup table).  My problem is that although in the

origional table and the query table the name shows, when I merge into Word

the ID code shows.  Any ideas?



Jo Buxton

Email: info@j...

Jo



Your problem is that the query actually holds the ID code, 

and Access does some fancy processing to display the name. As 

Word can't do this processing, all you get in the finished 

mail merge is the ID code.



You need to change your query so that it actually selects the 

text you wish to display in the Word merge.



	1. Open your query.

	2. Add the 'lookup table'

	3. Create a link between your main table and the 

lookup table on the ID Code field.

	4. Delete the field containing the ID code from the 

query grid.

	5. Drag the description field from the lookup table 

down to the query grid 

	6. Amend your Word document to expect the new field 

name.



-BDS 



-----Original Message-----

From:	jo@j... [SMTP:jo@j...]

Sent:	17 May 2001 11:28

To:	Access

Subject:	[access] Mailmerge from Access



I've got a Word mailmerge document that uses an Access query 

as its source

data.  One of the fields on the query shows a list of names.  

This field, 

in

the orignal table, is a lookup from another table using an ID 

code (the

primary key in the lookup table).  My problem is that 

although in the

origional table and the query table the name shows, when I 

merge into Word

the ID code shows.  Any ideas?



Jo Buxton

Email: info@j...



brian_skelton@o...

To unsubscribe send a blank email to leave-access-

472911E@p...

I usually export my queries into Excel (save to an external database in

Excel '97 format), clean them up if I need to (just in case you have

duplicates, etc.) and then merge from there into Word. Or another quick way

to get your data into Excel, providing your query is not very long, is to

copy it on the clipboard and paste in Excel.



-----Original Message-----

From: jo@j... [mailto:jo@j...]

Sent: Thursday, May 17, 2001 6:28 AM

To: Access

Subject: [access] Mailmerge from Access





I've got a Word mailmerge document that uses an Access query as its source

data.  One of the fields on the query shows a list of names.  This field, 

in

the orignal table, is a lookup from another table using an ID code (the

primary key in the lookup table).  My problem is that although in the

origional table and the query table the name shows, when I merge into Word

the ID code shows.  Any ideas?



Jo Buxton

Email: info@j...