Help fine tuning mail merge from switchboard
Windows Vista 
Access 2007
First off, I just want to say that I really respect what you guys do here. It is awesome that you take time from your lives to help people who really need it. Thanks all you contributors, you guys deserve more credit than you get.
At my office we have several forms and contract documents that we have automatically generated with the Word mail merge function. To try and make things easier for my not so tech savvy boss I have created a switchboard with several buttons to open the auto mail merge function through Word. The problem is now he has to find the person in the database and follow through with the rest of the wizard.
What I am hoping to achieve is:
A switchboard with a form, a label saying, For who do you want to generate this document?, he types in some text, clicks next, it pulls up a list of matches in the database. He clicks on the name he wants. A new form appears saying, which document would you like to generate, with a button for each document. When he clicks on the form, it runs the mail merge function, for the person he has selected.
I know that is a lot to ask and I don't expect anyone to write the entire switchboard for me. If someone could please explain how I can carry the variable selected when he chose a contact I think I could figure it out. I am used to doing this sort of thing through PHP and MySQL and I'm not sure how variables in web development relate to the way they work in Access.
Any insight on how to do this or links to software to generate what I need would be greatly appreciated. Paperwork is a real pain in a law office and I know my boss will appreciate the help as well. Thank you all for your time and your willingness to help random strangers. It really does mean a lot to me because I know that it is time you give up in your lives to help people who rarely give enough thanks.
Reply With Quote
