saved queryDef not showing in word for mail merge 1

[weezles]

hi

i have a queryDef which is saved and shows as a query in access but it doesnt show through word to do a mail merge. Is there any way i can save it, or even put it into a table?

Thanks

Lou

 

[dhookom]

Is the querydef a select query or an action query?

Duane
MS Access MVP

 

[taterease]

Lou, Duane,

I'm having the same issue on a select query - I can see the query in Access but not from Word.

Running XP Pro on clients, SP1; Office is on SP3; server is on Windows2003.

Any ideas gratefully accepted.

Jim

 

[dhookom]

Does your query have a parameter prompt or criteria? I never pull records from Access directly into a Word Merge. While in Access, I create a Word Merge data file. This separates the merge from Access since Word only deals with a separate file.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[taterease]

Thanks, Duane. The soluttion was that Word wasn't looking for DDE data sources...a long, involved story <g>. The user is in an office about 2.5 hours from my location and using a REALLY old Word doc that I set up several years ago. I haven't updated the related Access app in ages, and out of the blue I got a call that the link had failed. Had no idea it was still in use!

Thanks for the tip, tho, on how to do it properly!

Jim