...This could very well be. So is the final answer that after printing
successfully (64 addresses on 11 pages) from the "Main Document" saving
the
"Main Document" then reopening the "Main Document" all with out moving or
sending it anywhere that though I can see/scroll/preview all the data the
"Main Document" will not then print out all that information at one time
ie
all 64 addresses on 11 pages.
That's correct. This is where we started...
However a second party who has no access
experience needs to print out these addresses weekly is their some way to go
into the Word Doc and print all 64 addresses (11pages) at once?
....but I have made some invalid assumptions.
What /they/ need to do is
a. open the mail merge main document
b. get through the question about SQL
c. perform the merge (either printing the results or merging to a new
document and printing that)
They shouldn't need to know anything about Access to do that, only Word.
However, if you want to make it easier for them, you would also have to
a. train them to reply "Yes" to this stupid question (because of course
there is no reason why they would have any notion as to whether or not it
was "safe" to reply either Yes or No), or they can probably be spared this
particular question if their machine's Windows registry has been patched as
per
http://support.microsoft.com/?kbid=825765
b. provide a macro that did the merge when they opened the document.
Peter Jamieson
"GMcKenna" wrote in message
...
Peter:
I have added my thoughts ...as you go through your last reply
"Peter Jamieson" wrote:
OK, the .dot thing is irrelevant.
Let's run through it again.
From Access, you create a document. This is indeed the Mail merge Main
Document, and is connected to the data source.
..Ok good so far
But when you perform the merge to a new document, you end up with a
/second/
document. Let's call it the Results document. The Results document should
not
be connected to the data source.
...this makes sense
If you save the Mail merge Main Document, then re-open it, it will try to
connect to the data source. That's why you see the message about
SELECT*FROM
`NATPRODQuery. You should then be able to re-run the merge, but the merge
will use the current data.
... this is what i must have done saved the "Main Document", I get the
query
when I open it and it has the updated/current data from my database.
If you save the Results document, and re-open it, you should not see any
message about SELECT*FROM `NATPRODQuery. The Results document should just
contain the results.
..I am presuming I have not saved the "Results Document"
So if you save the Mail Merge Main Document and send it to someone else
who
does not have the same database, they will not be able to recreate the
Results document - they'll only see the Mail Merge Main Document, perhaps
with some preview data.
....The saved "Main Document" and the database are on a multi access drive
so I am not sending the saved "Main Document" anywhere it remains on the
drive it was saved to and that also has the main database file
If you send the Results document to someone else, they would typically be
able to print the results document without having the data source.
...see above
I just have a feeling that you are expecting Mail Merge to work in a
different way from how it actually works, and may be misinterpreting what
you are seeing.
...This could very well be. So is the final answer that after printing
successfully (64 addresses on 11 pages) from the "Main Document" saving
the
"Main Document" then reopening the "Main Document" all with out moving or
sending it anywhere that though I can see/scroll/preview all the data the
"Main Document" will not then print out all that information at one time
ie
all 64 addresses on 11 pages.
Graeme