Merging Data

G

Gail

I am tying to create a merged document from an access query. The data
consists of and employers name and address and a list of employees. When I
merge the data Word wants to create a separate page for each employee, is
there a way I can merge forming a list of employees and headed with the
employers name and address. I have no problem creating the merge data.
 
D

DL

You can create this report within Access, presumably there is a particular
reason for using word?
 
G

Gail

Thanks DL, yes I have created a report to make the list, but the reason for
using Word, is that the merged data is forming part of a letter to the
employer. hense the request, any further sugestions will be greatly recieved

Gail
 
D

DL

In the origonal Access query, is the 'grouping' correct. ie you run the
query and it lists the unique Employer then the employees for each.
Other than that, perhaps not 'neat/proffessional', but include the access
report as a seperate page for your letter.
 
G

Gail

Thanks for coming back to me, I have been shopping today and purchased an
Access developers book, that shows me how to use and access report in a word
template, so will give that a try. Thanks Again for trying, much appreciated

Gail
 
Top