Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 6th, 2006, 06:10 PM
Friend of Wrox
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default Secondary Data Source for Word Template

Perhaps this is not the proper Forum for this (and someone may be so kind as to re-direct me).

I have an .MDB that is set up to send information to a series of Word Templates through Mail Merge. We have had a series of changes in our leadership (with more to come) and our letterhead changes frequently. I would like to store the names of the individuals in leadership in a table in my MDB and then bind/link the fields in the template where individuals names go to the table. All the templates are already linked to other data tables, so I need to find a way to attach a second data source (preferably from the mdb)to the Templates. Then as changes in leadership occur, I can rapidly update all the Templates.

I've tried looking for something similiar to DLOOKUP in Word- no luck. And the data tables the leaders would be listed in are not related to the tables that provide to the OpenDataSource for the Mail Merge (so if I included them into the query it would produce a cartesian product.)

Any ideas as to how to do this or what I should research?

Thank You,


Reply With Quote
  #2 (permalink)  
Old May 8th, 2006, 12:36 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You can add the leadership to each field in the append/update or make table query you use for your Mail Merge tables. If the field is only pulled once at the top of the page for example, it won't matter that it is returned in each record since it won't be pulled on the form letter. In fact, it will be pulled once for each letter, so it will be used once for each letter. So that should work fine.

So if you add the leadership field to the mail merge tables, and then modify your form letters slightly, this should work. I don't think you need to do a second data source. Once you modify the table and open your Word mail merge doc, the field should show up in your current data source. Use it as often as you need it.


Reply With Quote
  #3 (permalink)  
Old May 9th, 2006, 07:48 PM
Friend of Wrox
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post

Thanks, I didn't think this one through the whole way.


Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Populate ListBox from a Secondary Data Sour luca ASP.NET 1.0 and 1.1 Basics 4 December 1st, 2004 05:24 PM

All times are GMT -4. The time now is 05:34 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.