Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multi-sourcing MM fields from Access DB
(Office 2002) Okay, here's the deal. I had been requested to create a MM
document sourced on an Access database. No problem. The data source was a single table. Fine. Then.... the requesting division needed additional capability in the data source (as in, keeping more "stuff" in tables and expanding what was to be placed into the Word document.) So this necessitated using a multi-table methodology. Now, I need to know IF there's a way to use multiple tables to source a single Word doc. I THINK that a query is out due to the level of complexity of the database as it (now) exists. What I THINK I need to do is, using VBA, spin through the document looking for specific bookmarks. When I find those, I need to do a database lookup and insert specific information into the document at those points. Sometimes the information will be in tables, and sometimes standard text. What I want to know is, what methodology is best suited to accomplish my task? I've been a database guy for over 25 years, and have a pretty fair knowledge of Word (but not VBA behind Word; I was thinking of opening the doc - hidden - in Access, and doing the VBA work from there). Anyway, if some of you folks could shed some light on how this all might be done, I'd sure appreciate it. The actual task being performed is the creation of IT "Service Level Agreement" documents. Each document contains a revision history, and multiple categories of services (which appear in different sections of the document), contact information (names, email addies, phone #'s, etc) and "external reference documents" (including descriptions, titles, network paths, etc). All this is specific to division, and there are 31 divisions in the agency. Again, any assistance or ideas would be most appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word and XML for single sourcing books | Microsoft Word Help | |||
Word and XML for single sourcing books | Formatting Long Documents | |||
Need help in starting out at single sourcing in Word 2003/XML | Microsoft Word Help | |||
Merging multi-line fields | Mailmerge | |||
Can you create a multi-layered merge where certain merge fields a. | Mailmerge |