Max Wanadoo
max.wanadoo at gmail.com
Tue Feb 5 08:19:50 CST 2008
Well, I can say that I do virtually all of that as well with the one
exception of user adding in comments during print time, but it would be easy
to implement that.
when I get time later, I will go through my routine and strip away the bits
that don't lend themself to what you are doing and then post it up. It is a
very long routine which is why I was just posting bits out of it.
It is based on Bookmarks in Word dot (not docs, but template dot files).
There is a master Word Doc which people copy, give a new name to and add the
text in and put any other bookmarks in (from a series of known bookmark
names that the this system understands). The calling form (but could be a
rst) is selected from a Combo (which letter do you want to send type thing).
The user can d/click on the selected letter and make changes if they want to
the DOT document. there are also clicks for paragraphs to be added in,
postscripts, donations, etc, etc. A whole range of stuff.
When the module is called, it is passed the form name. From that it will
know what sort of data is available and will open a NEW INSTANCE of word
object. It will then create a new document based on the selected DOT
document and populate the bookmarks. It will then create a new name which
is part system generated and part data orientated. If a word document
exists with the same name, it will append a sequential number and loop until
it gets a unique name. It then saves this. It then background prints and
stays there until the printing is completed (couple of millisecs typically)
and then closes the INSTANCE of the WORD Object. A usesr can hage multiple
word documents open if they wish, no problem as we are using our own
INSTANCE of the object.
The options are to Just Print it, Preview it, Cancel it. The document name
is then written to a linked table (PersonID and LetterID). it can be
retrieved at any time, previewed again, deleted etc - up to you). All
letters we send out are done via the database so that we know exactly what
was sent, who sent it, etc.
Obviously, I can't post up the whole suite but the above should give you a
general feel. Do you want the Word module posted or sent private (or not at
all)?
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, February 05, 2008 1:25 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automation of word
Max,
In this case the user selects from one of dozens of different documents
specific to a type of disability claim for a specific disability insurance
company. These documents are things like request for medical records,
notice of claim status, legal requests to lawyers, what have you. So the
user selects a specific document, then the people that will get a copy of
the document, who the "to" is, and who are CCs etc. They then click a
"merge" button and the data required for that specific document is dumped to
the text file, Word is opened with that specific document loaded. Word
pulls the data from the text file and then MAY throw up prompts to the user
to fill in other data that is not in tables, but rather is in the claim
processor's head (comment to the claimant etc).
Once the claim processor has finished and is happy with the document, (s)he
prints the document and closes word. Thus the process is a little more
complex than just "open and print a document".
What I am trying to accomplish now is to reliably get the document saved
after being filled in, as well as reliably get Word closed. This
application is call center software. My client, the user of the
application, has invested in a system to scan all paper and get it into
electronic format. The claim is a paper file, the document just created is
printed, but the paper is never touched after being placed in the folder.
All processing of the claim is done by looking at the document scans. The
entire claim is dumped to individual DVDs and those DVDs are sent to their
client (large insurance companies). The paper is sent to dead storage, it
has to exist for legal reasons but it never has to be actually looked at.
So... ATM the process of SAVING the document relies on the user to actually
do so. The document HAS to be saved to a specific folder in order for the
scan software to "see it". That software will open all documents in a
specific folder and import it into the document storage system, index it by
claim number etc. But if the document does not get saved, then it does not
get into the electronic version of the claim. ATM they take the paper copy
just printed, place it into a scanner and manually scan the paper into the
system but that is labor intensive. They do a thousand documents a day, and
they want to be able to reliably save the document into this special folder
and just let the doc storage do its thing without having to go through that
manual scan step.
Additionally closing of the WORD application depends on the user. I want to
gain control of the save and the close process. Thus I want to lock Word
open and force the user to click a button in Access so that my program can
save the document close Word and release my pointer to word, log that I
saved the document to doc storage etc.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, February 05, 2008 5:38 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automation of word
You can open Word and set it to background printing and then keep it open
until printing is completed and then close it down.
Is that what you are after?
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, February 04, 2008 4:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automation of word
Rocky,
In fact the method I am using is to export the data into t text file. The
word document is then "hard coded" to pull in data from that text document.
I just open the word document and it "just does it". Of course I have to
successfully export the data to the text file first.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, February 04, 2008 10:32 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Automation of word
John:
Can't help you with that but I'm curious to know the code you're using to do
the merge. I had a merge function and it used to work. Now, for reasons I
have yet to be able to figure out it doesn't. My code to open the document
and merge is only a few lines:
Dim objWordDoc As Word.Document
Dim objWord As Object
Set objWord = CreateObject("Word.Application")
With objWord
'Visible is set True in order to view the operation.
.Visible = True
.Documents.Open (strDocName)
.ActiveDocument.MailMerge.Destination = wdSendToNewDocument
.ActiveDocument.MailMerge.SuppressBlankLines = True
.ActiveDocument.MailMerge.Execute
End With
It starts word and opens the document just fine but at
.ActiveDocument.MailMerge.Destination = wdSendToNewDocument I get requested
object not available.
How are you opening and merging your document?
TIA
Rocky
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, February 04, 2008 6:49 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Automation of word
I have a rather elaborate mail merge system in a client's system. ATM I
open the document, merge the date and the user takes over, filling in things
that they need to fill in, then printing and closing the word instance. It
works well enough however I do not control the save of the document, and
very occasionally Word does not close cleanly, leaving a hidden instance
open WITH the associated merge text document open as well, preventing the
next merge from occurring.
I need to know if it is possible to open word in a mode that prevents it
from being closed by the user? I would then have the user go back to my
application and press a button saying that they succeeded in doing the mail
merge. I would save the document and close Word down.
Can I prevent the user from closing Word?
John W. Colby
Colby Consulting
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.19/1257 - Release Date: 2/3/2008
5:49 PM
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com