Access to Word Merge 2

[Cloonalt]

I have an interface that the user uses to select data. They print an Access report based on form variables.

The problem is that I can't really get all the formatting that they want in Access, so I'm looking at doing a Word Merge - launching Word from my Access interface. I've seen documentation on how to do this, but my report is based on a huge query - about eight tables - and it seems so cumbersome to write the SQL to do it this way - the SQL statement would be too long.

Can anyone suggest a way to do this efficiently?

Thanks.

 

[PHV]

You may consider converting your actual huge (but working) query into a make table query and then base your word mailmerge on this temporary table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lameid]

What kind of formatting can you do in word and not Access while still using a query? I'm guessing your question should be how do I do this stuff in an Access report? If you simply need a section that contains static formatted word text, simply embed the document in the report.

As for alternatives, I saw somebody once use bookmarks in word. Access then overwrote each bookmark with data. Kind of like a merge but it gave a more granular control over formatting.

I guess it really depends on WHAT you are trying to accomplish.

 

[Cloonalt]

lameid, I can't tell you how many times I've retyped letters in Access and never thought to just embed the letter. That's why I love this site.

In this case I have variables throughout the letter, so I'll look at the bookmark option.

Thanks.

 

[Cloonalt]

PHV, thanks I'll look at that option too.

 

[easyit]

Hi,
I have another approach. I use a word template (*.dot). Access generates a flat textfile which in turn is used in a mailmerge action with the new worddocument.

I manipulate the wordocument from access.

EasyIT