I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the current document. 6) At this
point the user prints the document and the process is done. 7)The process
takes about 5-10 seconds.

Here is my question: my client want to be able to push a button from Access
and everything will be done except selecting the document to insert at the
end of the mailmerge document. I have tried several different approaches.
Each is not a single step process, some have warning messages that show up,
etc. Is it reasonably possible to come up with a perfect solution here? Is
there a perfect solution out there somewhere. All the solutions I have seen
are not "perfect".
I would appreciate your candor and help.
--
Thanks!
Gary S

Sounds like you've already doe a lot of work on this and what you're trying
to accomplish seems reasonable. If you're to the point of Warning Messages,
and that's your only roadblock now, why not temporarily disable those
messages?

docmd.setwarnings false

but you should turn it on again after the update query finishes by:
docmd.setwarnings true

So . .
Public Sub DeleteSomething()
docmd.setwarnings false
.. . . your code in here . .
docmd.setwarnings true
End Sub

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary S" wrote:

> I have setup a Mailmerge that is run from Access. The process works like
> this: 1) The proper record is selected in an Access form which automatically
> starts the process. 2) Word is called up automatically, it shows both the
> template and the doument with the proper data in it. 3) Access is closed
> automatically. 4) The user then needs to close the mailmerge template. 5)
> The document with the proper mailmerge information inserted from Access is up
> on the screen. At this point a shortcut is triggered by the user that adds a
> document of the users choice to the end of the current document. 6) At this
> point the user prints the document and the process is done. 7)The process
> takes about 5-10 seconds.
>
> Here is my question: my client want to be able to push a button from Access
> and everything will be done except selecting the document to insert at the
> end of the mailmerge document. I have tried several different approaches.
> Each is not a single step process, some have warning messages that show up,
> etc. Is it reasonably possible to come up with a perfect solution here? Is
> there a perfect solution out there somewhere. All the solutions I have seen
> are not "perfect".
> I would appreciate your candor and help.
> --
> Thanks!
> Gary S

Thanks for the reply. Sorry I was not clear. I was referring to security
warnings and the such. The real issue here is that it seems to me that you
could almost come up with the perfect mailmerge in earlier versions of
Office, but in 2007 that does not seem to be the case, could someone confirm
that train of thought or direct me to an automated mailmerge method in Office
2007.
--
Thanks!
Gary S


"ryguy7272" wrote:

> Sounds like you've already doe a lot of work on this and what you're trying
> to accomplish seems reasonable. If you're to the point of Warning Messages,
> and that's your only roadblock now, why not temporarily disable those
> messages?
>
> docmd.setwarnings false
>
> but you should turn it on again after the update query finishes by:
> docmd.setwarnings true
>
> So . .
> Public Sub DeleteSomething()
> docmd.setwarnings false
> . . . your code in here . .
> docmd.setwarnings true
> End Sub
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "Gary S" wrote:
>
> > I have setup a Mailmerge that is run from Access. The process works like
> > this: 1) The proper record is selected in an Access form which automatically
> > starts the process. 2) Word is called up automatically, it shows both the
> > template and the doument with the proper data in it. 3) Access is closed
> > automatically. 4) The user then needs to close the mailmerge template. 5)
> > The document with the proper mailmerge information inserted from Access is up
> > on the screen. At this point a shortcut is triggered by the user that adds a
> > document of the users choice to the end of the current document. 6) At this
> > point the user prints the document and the process is done. 7)The process
> > takes about 5-10 seconds.
> >
> > Here is my question: my client want to be able to push a button from Access
> > and everything will be done except selecting the document to insert at the
> > end of the mailmerge document. I have tried several different approaches.
> > Each is not a single step process, some have warning messages that show up,
> > etc. Is it reasonably possible to come up with a perfect solution here? Is
> > there a perfect solution out there somewhere. All the solutions I have seen
> > are not "perfect".
> > I would appreciate your candor and help.
> > --
> > Thanks!
> > Gary S

I use albert Kallals word merge code, no warning messages. Should do what
you want or at a minimum give you a way to appproach word merging.
http://www.members.shaw.ca/AlbertKal.../msaccess.html

Just needs a tiny tweak if you are using .docx extentions instead of .doc

HTH,

--
Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Gary S" <(E-Mail Removed)> wrote in message
news:71DA00B6-6E44-409A-8A8E-(E-Mail Removed)...
> I have setup a Mailmerge that is run from Access. The process works like
> this: 1) The proper record is selected in an Access form which
> automatically
> starts the process. 2) Word is called up automatically, it shows both
> the
> template and the doument with the proper data in it. 3) Access is closed
> automatically. 4) The user then needs to close the mailmerge template.
> 5)
> The document with the proper mailmerge information inserted from Access is
> up
> on the screen. At this point a shortcut is triggered by the user that
> adds a
> document of the users choice to the end of the current document. 6) At
> this
> point the user prints the document and the process is done. 7)The process
> takes about 5-10 seconds.
>
> Here is my question: my client want to be able to push a button from
> Access
> and everything will be done except selecting the document to insert at the
> end of the mailmerge document. I have tried several different approaches.
> Each is not a single step process, some have warning messages that show
> up,
> etc. Is it reasonably possible to come up with a perfect solution here?
> Is
> there a perfect solution out there somewhere. All the solutions I have
> seen
> are not "perfect".
> I would appreciate your candor and help.
> --
> Thanks!
> Gary S