Repeat the fields
Hi Nit_Wit_400,
A Word mailmerge main document can have only one data source, so what you want to do isn't possible in the way you want to do it.
You could try running a db query to extract the data from each database into a single table that Word could use as its mailmerge
datasource.
--
Cheers
macropod
[Microsoft MVP - Word]
"Nit_Wit_400" wrote in message ...
Hello all.
Is there any way to set up my mail merge fields to stay whenever I
merge from a database.
For instance, I have multiple databases which are all set up the same
way, and I need to merge them into one word document with the same
repeating format.
For example:
((DB1)) Nottle: 36,375.0-125.J-00-000 and 15.23 acres, abstract no.
0511092101-02;
((DB2)) Nottle: 36,375.0-125.C-00-000 and 15.24 acres, abstract no.
0511092101-06;
((DB3)) Hons: 36,375.0-125.A-00-000 and 1.09 acres, abstract no.
0511092101-07;
((DB4)) Herman: 36,375.0-125.B-00-000 and 7.30 acres, abstract no.
0511092101-01;
((DB5)) DiGian: 36,375.0-125.F-00-000 and 17.17 acres, abstract no.
0511092101-04;
((DB6)) DiGian: 36,375.0-125-E-00-000 and 17.70 acres, abstract no.
0511092101-03;
So on and so forth.
The fields being Last Name: Number and Number acres,
abstract no. Number;
If there is any way to make those fields repeat like that without
having to copy-paste them, or whatever, please help me out?
|