Thanks to the help of the many Access gurus online, I have built a custom rolodex which is a almost litigation secretary's dream. It's been a steep learning curve the last few months, but I've done it.
Now, I need to make the final hook-up. Specifically, I need to be able to import from Access the addresses of people to whom we are writing.
What I envision is a form in Word which has a combo box populated by the Contact list in the Access rolodex. The secretaries would be able to make multiple choices of contacts (we often write to 4 or more people at a time); the addresses would be placed in a two-columned Word table as text. We also need check boxes to get the appropriate "heading" on each addressee's letter -- attorney-client privilege, joint-defense privilege, etc., and a check box for whether the letter is sent by fax and/or e-mail including the fax number or e-mail address (e.g. "via telecopier -- [fax number]
I've tried using MailMerge or Insert Database field, but it doesn't do what I want, and causes other problems (such as opening the Access database 3 times without ever closing any instance of it -- very slow, very annoying, and very cumbersome). So, any guru's out there with the Automation experience to help this decidedly inexperienced potential VBA user?
Thanks in advance.
Now, I need to make the final hook-up. Specifically, I need to be able to import from Access the addresses of people to whom we are writing.
What I envision is a form in Word which has a combo box populated by the Contact list in the Access rolodex. The secretaries would be able to make multiple choices of contacts (we often write to 4 or more people at a time); the addresses would be placed in a two-columned Word table as text. We also need check boxes to get the appropriate "heading" on each addressee's letter -- attorney-client privilege, joint-defense privilege, etc., and a check box for whether the letter is sent by fax and/or e-mail including the fax number or e-mail address (e.g. "via telecopier -- [fax number]
I've tried using MailMerge or Insert Database field, but it doesn't do what I want, and causes other problems (such as opening the Access database 3 times without ever closing any instance of it -- very slow, very annoying, and very cumbersome). So, any guru's out there with the Automation experience to help this decidedly inexperienced potential VBA user?
Thanks in advance.
