[AccessD] Mail Merge - Verifying user is satisfied and completed the merge

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 20 13:11:06 CST 2004


Um ... Raise an event in Word?

Charlotte Foust

-----Original Message-----
From: Colby, John [mailto:JColby at dispec.com] 
Sent: Tuesday, January 20, 2004 10:49 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Mail Merge - Verifying user is satisfied and
completed the merge


yes, in Access.  Access opens the word document, merges the data and
waits for the user to edit the data..  The user edits the document to
their hearts content, then closes the document.  Access continues
processing, saving the document out to a network drive and logging the
successful merge to a table.

In order to do this, I need to know the user successfully merged the
document and was happy with the results.

John W. Colby
The database guy


-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Tuesday, January 20, 2004 1:37 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Mail Merge - Verifying user is satisfied and
completed the merge


Are you asking about stopping the processing in Word or Access?

Charlotte Foust

-----Original Message-----
From: Colby, John [mailto:JColby at dispec.com] 
Sent: Tuesday, January 20, 2004 10:29 AM
To: Accessd (E-mail)
Subject: [AccessD] Mail Merge - Verifying user is satisfied and
completed the merge


I am attempting to set up a system where one group of people "order"
merged documents, and another set of users then print those ordered
documents, QA and mail them out.  The users that order the documents
will do the mail merge (on their local machine), with the document
opened and visible to them after the merge.  The user can then edit the
document (add sentences / paragraphs etc), scan that the merged data is
correct etc.  

If they are happy then I need to save the merged document out to a
common location on the network with the doc name modified to include the
initials of the person ordering the document, the date, the claim number
that the doc is about etc.  If the user is not happy, I need to just
delete the
document(s) on the local drive.

My question is, how do I stop processing as I open the document so that
I can then ask the user if it all worked satisfactorily after they close
the document.  Is it possible to "open the document MODAL (so to speak)
where they are in Word, can edit and do whatever, but they have to close
Word to get back to Access?  

How do you guys handle this stuff.

John W. Colby
The DIS database guy

_______________________________________________
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


More information about the AccessD mailing list