Office 2003.Word Mail Merge from Access Parameter Query. Possible?

Posted on 2006-05-25
Last Modified: 2011-10-03

I use Office 2003 Pro. I wish to create a mail-merge letter in MS Word that gets its data from a parameter query in Access 2003. The query I wish to use, prompts users for a start membership numbe, End membership number and betwwen first and last date and brings up the data within the constraints of their input.

If I use the mail-merge wizard in MS Word to link to the database, it shows all the queries EXCEPT those that require user input for the parameters.

Is it not possible to create such a mail merge with parammeter input. So far I have had to create a normal query and change the criteria section in the query design. This is long a laborious and I often forget to do it before running the query

What am I doing wrong? Is it possible to do a mail-merge with a query that requires user input for its parameters and if so how as I have tried every option in the Word Mail Merge Wizard to no effect

Question by:arwood
    LVL 65

    Expert Comment

    this is how u do it with Word 2000
    perhaps this may help u;en-us;214183&Product=acc
    LVL 77

    Accepted Solution

    Hi arwood,
    The native connection from Word to Access in Office 2003 is different to previous Office versions and the technology which allowed the use of Access parameter queries in previous versions is quite well hidden in Office 2003 and pretty awful even when you get to it.

    If you check the setting in Word
    Tools|Options|General|"Confirm conversion at open"
    you can get the mailmerge doc to ask the right Qs and you can choose the DDE route which is essential if you want to use a parameter query.
    When you get to choose the Data source, ignore all the given options and just browse to your Access file and select it.  You will then be able to choose the dde option.
    The real problem is that the Access parameter dialog does not come to the top and you have to switch to Access using the taskbar to see the parameter prompt.  This is wretched for users.

    But the whole of mail-merge in Office 2002/3 is a mess IMHO.

    LVL 44

    Expert Comment

    by:Leigh Purvis
    I agree - and was saying that very thing in a recent question Pete.
    It could have been good, nice idea - but they dropped the ball on that one (or at least spooned it way over the net).

    You can set it to do as much (i.e. use a DDE connection) in code
    (my comment is riiight at the end).

    I have to say though - my preference is to merge with a table.
    It's just safer and generally faster.
    All you need to do is execute a delete and then an append query first - and merge to that table.

    (Of course - if you're not initiating the merge from Acces - then that ain't so straight forward)

    Author Comment

    Hi Rockiroads

    Tried it and found what peter57r is saying  in his first para which I have just seen. Sorry it did not work  but many thanks for the exceptionally quick reply


    Will now look at the replies from Peter57r and LPurvis

    Author Comment

    Hi Peter

    Tried your solution and it works no problem with the proviso you give, ie it is very well hidden in the options and the kludge of having to select the parammeters in Access which are underneath so you are not aware they are there. After saving the final document however that does not occur so it is just a quirk that I can live with. I actually had several existing merge documents linked to Queries. I converted the queries to Parammeter queries and then found that the documents would not link any more. That was when I tried to change the source data and found that it would not list the Parammeter queries. I then tried to creat a new document with similar results. That was the point at which I consulted the experts. I would never have found that Option setting in a hundred years so thanks very much. All my previous documents are now up and running again but with the parammeter entry facility.

    Thanks again and as the first one I allocate the points to you with thanks toLPurvis for his comments which I am not really able to comment on as VB is something I have never really gotten into.

    Regards and thanks to all.

    LVL 77

    Expert Comment



    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now