View Single Post
 
Old 05-02-2011, 06:47 AM
Evis Evis is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2011
Posts: 3
Evis is on a distinguished road
Default Simplified Mail Merge From a Query

Hello everyone.

The problem is pretty simple- I'm working on a database for a friend who is running a small business. She's like to be able to use the database for a mail merge- simple enough, but from her requirements I'd like to be able to vary the criteria on the searches, and so use variable paramaters in them.

She isn't very computer literate, so teaching her to change the query paramters in design view is a last resort.

I can set up a query which will either use user defined paramaters [enter info here] or lookup a value in a form [Forms]![Infodump]![contactgroup] (For example), and these work fine on Access. However, they fall on thier backside when I try to use these queries to make a merge with MS Word.

So, is there a way around this? Or are there other methods I can use that would keep defining the query parameters simple? Any advice would be hugely appreciated. Thanks to you all for your consideration.
Reply With Quote