using an Access report as data source?

[Han]

I have a report in Access that gets its data from multiple queries.
Collecting all this data in one query is not possible due to the number of
references to the same table. I have several UserIDs and need to
conditionally retrieve contact information for each. Fortunately doing this
in Access is a breeze and the report looks great.

I'm trying to replicate a variation of this report in a mail merge template
and so far have been unsuccessful. Word only seems to support one data
source: a table or query. I read somewhere that Word can use an Access
report as a data source. Is this possible?

I've hit a wall here and would appreciate any suggestions.

Thanks in advance.

Han

 

[Peter Jamieson]

Please see my replies to your earlier questions for various suggestions in
this area.

I read somewhere that Word can use an Access
report as a data source.

You can't /connect/ to a report and use it as a data source directly. But
since you can export report results in various formats including rtf, if you
can get the output of a report to look like a simple delimited list with
headings or a table, you may be able to export it and use the .rtf as a data
source. Or the article you read may have meant
a. "you can export a report as rtf and edit it in Word. Which you can, but
since Access basically generates graphical output it can be a messy and
frustrating business.
b. "you can take the query that underlies a report and use that as a data
source".

 

[scott]

We will export the report to an Excel spreadsheet and use
Excel as our data source.

 

[Han]

Hi Peter,

Thank you very much for your help.

I have talked it over with my client and we have decided to hand off the
mail merge stuff to a MS Word guru. I am a web application developer and
believe my client would be best served by someone who works with MS Word all
the time.

How does one go about finding a MS MVP in my area?

Thanks in advance for your response.

Regards,
Han