mailmerging multiple datasheets

[Guest]

I need to mailmerge the contents of an excel workbook into
word

When I try and do this it olnly merges the records held on
the first datasheet and ignores all other datasheets

How do i solve this problem

Thank you

 

[Andy Brown]

How do i solve this problem

AFAIK you can't, the merge will only ref the "front" sheet in the workbook.

So you can either combine the sheets into one, or perform the merge x times
(x being however many sheets you have).

Rgds,
Andy