Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dennis Dennis is offline
external usenet poster
 
Posts: 50
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word and XML for single sourcing books Jose Valdes Microsoft Word Help 2 March 8th 07 03:56 PM
Word and XML for single sourcing books Jose Valdes Formatting Long Documents 2 March 8th 07 03:56 PM
Need help in starting out at single sourcing in Word 2003/XML [email protected] Microsoft Word Help 1 December 13th 06 03:59 PM
Merging multi-line fields Matthew Hustings Mailmerge 1 May 18th 05 03:07 PM
Can you create a multi-layered merge where certain merge fields a. mileszat Mailmerge 3 January 18th 05 03:46 AM


All times are GMT +1. The time now is 12:17 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"