troubleshooting Question

Mail merge Save on close

Avatar of chestera
chestera asked on
Microsoft Access
34 Comments1 Solution386 ViewsLast Modified:
Hi

Over the last few months I have learned heaps about Mail Merge through EE. I now wont to Saveas when the Document is closed
1. I have a Doc.dot
2 it's merged via an access table
3. One of the Fields contains Patient number
4. The form in access has a text box where the user enters the Patient number and then from a list they choose a Letter. The access table is populated with that patient details
5. The document contains Patient number plus other details Name address etc
6. The user wonts to save the doc as "Patientnumber-Date.doc" (45-10-Feb-2006).
My question, is there a common variable that can be used by both Access and word, If not is it possible to get Patient number from the document

Any help most appreciated

chestera

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 34 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 34 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros