Mail Merge data source queries missing

[UTS]

I have seen this in earlier versions of access (currently using 2010) but cannot remember how I solved it.



Creating a Word mail merge using an access query as the data source. When pointing to the data sources, all tables are there, but some queries are not listed.

Curiously, the unlisted ones are those that prompt for user input. And, yes, it's one of those I need to access.

Any ideas?

Cheers,

[June7]

Test with a fixed value in place of the input prompt. Does the query show? That should reveal if prompts are the issue. I almost never use input parameters in queries and I NEVER use parameter prompts. Too hard to validate input and apparently has other issues. I have users provide input on a form and then usually use the WHERE argument of DoCmd.OpenForm[OpenReport] method.

[UTS]

Test with a fixed value in place of the input prompt. Does the query show?

Yes it does. However, this appears to be a shortcoming of Office 2007/10 where merging Word with a parameter query is near on impossible.

I have wasted countless hours trying to get something to work with 2007/10 that worked perfectly in Office 2000, but now seems bigger than Ben Hur!

All I want is a button on a form that when clicked, the user is prompted for a date, and then a bunch of letters appear on the printer. That's all.

Cheers,

[June7]

Why Word merge? Will an Access report serve purpose?

[UTS]

Why Word merge? Will an Access report serve purpose?

That would be OK for the envelope labels, but the letters are form letters i.e. fields scattered among the text. So I think Word would be best for the output. (Unless there is a form letter report in Access I am not aware of, that is)

Cheers,

[June7]

So the letter body is boilerplate text and the variable info is all data in Access tables? An Access report could be set up to do this. Just a matter of textboxes that concatenate static text with fields of report RecordSource.

[UTS]

Sounds painful, but I will give it a go.

Cheers,