Discussion Locked

Word 97 mail merge w. multiple sources

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm an inexpert user of Word, tasked with performing a mail merge with some very complex criteria. I'm pulling data from an Oracle database, but due to the nature of the data, I can't pull all of the data together into one data source.

For example, my merge will create one document per employee in our company. Much of the data is on a "one row per employee" basis, and I have no problem merging that. However, certain parts of the documents have a "many rows for one employee" relationship.

So, what do you suggest? Some questions:

1. Is there any way for mail merge to handle multiple data sources?
2. If not, are there any approaches (master/sub documents?) that I could take that would allow me to create multiple documents and then merge the results?
3. Is there any way to use mail merge or anything to actually generate a separate Word file for each row of data, or can you only have it output to one big file or a printer?
4. If #3 is possible, can you use some sort of intelligence to assign the name to the Word documents?

I do have access to some people with VBA experience, if that's necessary, so bring it on!

Please let me know what you think.

9 replies

by maxwell edison

With Mail Merge you can create your own data source or use data from multiple applications like an Access table or query, an Excel database, or even your Exchange or Outlook addressbook. I'm not sure about Oracle, but try it with these steps.

To perform a mail merge in Word, go to Tools->Mail Merge. A dialog box will come up. Perform each of the following steps in this order:

Step 1:
Click on Create and then choose the type of mail merge you would like to create, Form Letters, Mailing Labels, Envelopes, or Catalog. You will be prompted by Word to choose whether you would like to create this document in the active window or create a new document. You may choose either, however, choosing the active window will overwrite the information you have in that document.

Step 2:
Click on Get Data and then choose the source of the data to be used in your document. It is possible to create new data by selecting Create Data Source and then entering the information. You can also use an already created data source by selecting Open Data Source. You may use your Exchange or Outlook addressbook by selecting Use Address Book and then selecting the address book you would like to retrieve the information from. Finally, it is possible to use separate header and data sources. You can do this by choosing Header Options and choosing the sources of the files or creating them from scratch.

Note: In order to perform a mail merge you will need to add the mail merge fields to the main document before you will be able to complete the merge.

(continued..)

by maxwell edison

.
.
Step 3:
When all the information is entered into your data source and your main document is complete, you can merge your data and main document to create a third document, or merge directly to your printer, or merge electronically. Click Tools then Mail Merge and then the Merge button to view your options. It is possible to sort or filter during the merge to retrieve exactly the data you want in the order you want.

Good luck,

Maxwell

by Member 36391462

Thanks for the answer. Unfortunately, I'm pretty familiar with the basic mail merge functionality. Perhaps my question wasn't clear enough, but my problem is that I don't have a nice, clean, single data source, so I'm not sure if there is a way to merge this information.

Here's an example. Let's say the master document is an employee skills inventory. On page 1 there is some basic employee demographic data - one piece of info for each employee. On page 2 of the master document is a skills list, where there can be anywhere from 0 to 15 rows of data for one employee.

As an end result, I need one document for each employee, but I can't figure out a way to merge all of that information.

by dklippert

Depending on what you're looking for, check out Catalog rather than Form letter.
Observe how Word formats a Label merge.
You also might be able to use the "NEXT" or "NEXT RECORD IF" fields. You can use IF statements in a merge doc.

by sankulpune

Hello Steve,

What I feel is Word may not be able to provide the solution to this problem. Oracle is where you are most likely to get the solution to this problem.

What you may need to do is to create a single query (based on may be multiple queries and tables) that will provide you a single source of data. It may not be efficient but will serve your purpose.
You can then use this as source for mailmerge in Word.

I have been able to create such queries in MS Access, but I don't know much about Oracle. May be, an Oracle expert can help you to create the query.

Hope this heps a bit.

With best regards,

SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.

This discussion is closed to new replies.